Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

how to create temparary sequence

2 Answers   TCS,

What does the file extension accdb stand for?

0 Answers  

What is auto increment?

0 Answers  

when is the use of update_statistics command? : Sql dba

0 Answers  

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

What is sharding in sql?

0 Answers  

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

Why do we go for stored procedures?

0 Answers  

What is denormalization in a database?

0 Answers  

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

0 Answers  

How to avoid using cursors?

0 Answers  

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

For more SQL PLSQL Interview Questions Click Here
Categories