Tag Info

New answers tagged

0

It sounds like you're dumping 30 million rows into an existing table, then immediately trying to update those rows. I have a couple of thoughts, which may or may not work for you (since I can't see your code currently): 1) Is there a way to combine the inserts with the updates? It seems suspect to me that you're creating 30 million rows, then immediately ...


0

The following post answers my question and we ignored the stoplist when we created the indexes. https://community.oracle.com/thread/2181803


1

You can't use contains because there is no Oracle Text index on the database source. You could, I suppose, write a query that copied the data from dba_source to a custom table, create an Oracle Text index on that table, and search that table using the contains function. It would generally make more sense, though, to just query dba_source with a like query ...


0

Solution found. After some research I got to a nice example on how to find the current user via dual. The solution is pretty simple just add select sys_context( 'userenv', 'current_user' ) into user_name from dual; and user user_name instead of user. The body looks as follows CREATE OR REPLACE PACKAGE BODY PKG_DONE AS PROCEDURE ACK_FROM_WEB(P_UUID ...


1

You can use one of the functions of Oracles owa_util's package named WHO_CALLED_ME. To demonstrate this feature, we can create a table which will store the results of the call to Oracle's procedure. create table T_CALLSTACK ( OWNER_NAME varchar2(30), OBJECT_NAME varchar2(30), LINE_NUMBER number, CALLER_INFO varchar2(100), ...


1

Valid cursor attribute name is one of %NOTFOUND, %FOUND, %ROWCOUNT, %ISOPEN. There is no %rownum attribute . In your question you use implicit cursors, so it should be sql%rowcount.


1

I suspect you're using multiple sessions and the other session cannot "see" the work performed because it is currently uncommitted. The default Oracle transaction Isolation Level is Read Committed. This means that a session will not be able to see the work a given session has done until it has explicitly committed the transaction. The Oracle Server ...


1

You can use SQL%ROWCOUNT. This return rows processed in last sql statement For example: declare res number; begin select 0 into res from dual; dbms_output.put_line(sql%rowcount || ' rows selected'); end This code prints 1 rows selected because you selected one row. I hope this helps


0

Similar to Niraj Patel select regexp_substr('hello how are you doing', '[^ ]+', 1, level) || ' ' || regexp_substr('hello how are you doing', '[^ ]+', 1, level+1) val from dual connect by level <= length(regexp_replace('hello how are you doing','[^ ]+'));


0

If you are using Oracle 11g or onwords version then try this SELECT REGEXP_SUBSTR('hello how are you doing','[^ ]+',1,level) AS reg_result FROM DUAL connect by REGEXP_SUBSTR('hello how are you doing','[^ ]+',1,level) is not null ;



Top 50 recent answers are included