Tag Info

New answers tagged

0

Just like Leigh mentioned in another answer. Considering you case in terms of user behaviour and load is critical. Having said that, there are two options to do this. One is rownum and the more recent is the row_number analytic function. row_number can do more things but in this particular case there is no little to no difference in how the code would look. ...


1

Each element of a name must be quoted individually: drop java source "SCHEMA"."JAVASOURCENAME"; The identifier "SCHEMA.JAVASOURCENAME" refers to a java source name SCHEMA.JAVASOURCENAME in the current schema, e.g. "VORIAND"."SCHEMA.JAVASOURCENAME"


0

Personally, I would start with DBA_HIST_ACTIVE_SESS_HISTORY, and look at all statments that contain that type of hint. From there, you can pull the index name coming from that hint, and then do a lookup on dba_indexes to see if the index exists, is valid, etc. You should be able to do this via PL/SQL if you want to make it really fancy and do it all in ...


0

The data of a temporary table is only visible for the same session (or transaction, depending on the temp table properties) that wrote the data.


3

It sounds like you want WHERE date_entered BETWEEN sysdate - interval '2' hour AND sysdate Assuming date_entered never contains future dates WHERE date_entered >= sysdate - interval '2' hour Depending on exactly what you need (and why you're running the query), you may want to truncate the date to the hour or minute so that ...


3

Why don`t you dip into the manual SQL Language Reference, Appendix D, Oracle Regular Expression Support: [] Bracket expression for specifying a matching list that should match any one of the expressions represented in the list. A non-matching list expression begins with a circumflex (^) and specifies a list that matches any character except for ...


1

I don't think the backslash has a special meaning within the brackets. You can either use it as it is: regexp_like('a]b','[]]') or use an or: regexp_like('a]b','([whatever]|\])'). Any reason you can't use regexp_like('a]b','[^[:alnum:]]')?


6

Have you seen this? https://community.oracle.com/thread/889338?start=0&tstart=0 It states you can only exchange partitions from a partitioned table to a non-partitioned table, or vice-versa. You'd need to temporarily exchange the partition into an interim, non-partitioned, table, then into the target partitioned table. There are some interesting ...



Top 50 recent answers are included