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


What cursor type do you use to retrieve multiple recordsets?

Answers were Sorted based on User's Feedback



What cursor type do you use to retrieve multiple recordsets? ..

Answer / chandrasekar

Explicit cursor

Is This Answer Correct ?    81 Yes 7 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / sdp

Explicit cursor

Is This Answer Correct ?    43 Yes 1 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / guest

cursor <<cursorname>> is select * from <<table name>>

Is This Answer Correct ?    55 Yes 16 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / sri

Im sorry..sys_refcursor. can be used to pass cursors from
and to a stored procedure.

Normally we r using. CURSOR cursor_name IS SELECT...
So this is called explicit cursor.

Is This Answer Correct ?    19 Yes 1 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / rao

Using REF CURSOR only

Is This Answer Correct ?    20 Yes 6 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / sri

This ans opt for Oracle DB
---------------------------

SYS_REFCURSOR. this is what we called Explicit cursor.

In database if u run any sql statement by default system
will create a cursor. its called "Implicit cursor".

But in PL/SQL, we r using SYS_REFCURSOR to manupulate the
multiple records. that is called Explicit cursor.

Is This Answer Correct ?    15 Yes 5 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / guest

explicit cursor

Is This Answer Correct ?    12 Yes 3 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / pintu

It can be used Using REF CURSOR only.

Is This Answer Correct ?    11 Yes 3 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / vishu

SYS_REFCURSOR

Is This Answer Correct ?    12 Yes 4 No

What cursor type do you use to retrieve multiple recordsets? ..

Answer / venkat

using explict cursor we process multiple rows

syn:
cursor <cur_name> is select * from <tab_name>

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what are tables and fields? : Sql dba

0 Answers  


Can we enter data in a table in design view?

0 Answers  


What is synonyms?

0 Answers  


How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,


if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,


Give the order of sql select?

0 Answers  


When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,


What is sql and also describe types of sql statements?

0 Answers  


what are the disadvantages of mysql? : Sql dba

0 Answers  


How do I run pl sql in sql developer?

0 Answers  


Why truncate is faster than delete?

0 Answers  


in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,


Categories