What cursor type do you use to retrieve multiple recordsets?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

17 Answers
64683 Views
Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro, I also Faced
E-Mail Answers

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