i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify?

Question Posted / nagapawan

Answers were Sorted based on User's Feedback

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / sureshkumar somayajula

Hi ,

It will use in PL/SQL. Reusability of Cursor is nothing
but "REF CURSOR".These are of 2 types.

1. Weak Ref cursor 2. Strong ref Cursor.

Is This Answer Correct ?

9 Yes

0 No

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / raghu

Ref cursor comes in PL/SQL.
You can return a ref cursor in a function.
A ref cursor is useful while returning more values.

Is This Answer Correct ?

8 Yes

1 No

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / murali

ref cursor is of pl/sql topic

the main use of Ref Cursor is we can create multiple activeset area using refcursors

Is This Answer Correct ?

1 Yes

0 No

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?..

Answer / nirma durra

Ref-Cursor is DataType

Is This Answer Correct ?

0 Yes

0 No