1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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....

Question Posted / sweetsarao


1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use ..

Answer / 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

More SQL PLSQL Interview Questions

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

How do I get sql certification?

0 Answers  

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

how to create object in plsql

2 Answers   TCS,

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,




Why schema is used in sql?

0 Answers  

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

Why do you partition data?

0 Answers  

What is interval partition?

0 Answers  

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

Why truncate is faster than delete?

0 Answers  

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories