Please post the your query. We will check and provide the suggestion to fix.
Thanks to all.
Yes its working. What is the reason and why its not working when i give the extend(i).
Suppose both trigger will created before then statement level first next row level trigger. Consider the scenario you have 2 row level...
You can disable/enable the trigger when creating or using alter you can disable the trigger after creation. Please find the below code....
TYPE TEST IS TABLE OF NUMBER; --Nested table
TESTX TEST := TEST ();
Thanks Rajen for the reply.
I know we can able to get the details by enabling the trace. Do you know any tables to get the these details(Without...
Thank you rajen and Sergey Krasnoslobodtsev for the reply.
As per my understanding, if cursor_sharing parameter is "EXACT" then it should use...
created the table by using the below script.
CREATE TABLE TEST AS SELECT CASE WHEN ROWNUM BETWEEN 1 AND 10 THEN 100 ELSE 200 END A,...
Is there any way to find the what are the statements are executed in the particular session. Thanks in advance.
Please provide the table desc and number of records. post the query what you have written. There are many ways available to group the...
In above example i have just swap where condition to get outer join of both table with left outer join condition itself.