1.when will you use week refcursor and when will you use
strong ref cursor ?
2.what is the use of sql trace..how do you use it ?
3.can you please send all the sql plus commands...like set
line 6000....
Answer Posted / gourvendra singh
Strong Ref Cursor: Strong ref cursor are predetermined and
so we cannot use query having different structure then the
defined one
Week Ref Cursor : Week Ref Cursor are not predetermined and
so we can use query having different structure then the
defined one.
With the help of SQL Trace we will get the result of the
query with the execution plan and statistics of the query.
It is very difficult to send you all the SQL Plus Command,
you can check the same in SQL Plus window under option menu
in Environment there you will find all the SQL plus
commands.
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Is crud a cuss word?
What is an inner join sql?
Whis is not false in primary key?
Which kind of parameters cannot have a default value in pl sql?
Is not equal in sql?
Is full outer join same as cross join?
How we can update the view?
What is where clause in sql?
What is nosql vs sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is the difference between functions, procedures, and packages in pl/sql?
What is relationship? How many types of relationship are there?
does sql support programming? : Sql dba
What is faster join or subquery?
What language is oracle sql developer?