Re-usability of a cursor is nothing but " REF CURSOR". It is of

what is ref cursor in pl/sql?

Question Posted / suresh kumar somayajula

3 Answers
22267 Views
I also Faced
E-Mail Answers

Answer Posted / suresh kumar somayajula

Re-usability of a cursor is nothing but " REF CURSOR".
It is of 2 types.
1. Weak REF Cursor
2. Strong REF Cursor.

SYNTAX:
1.Strong Refcursor
SYN: TYPE <TYPE_NAME> IS
REFCURSOR RETURN <RETURN_DATA_TYPE>
2.Weak Refcursor
SYN : TYPE <TYPE_NAME> IS
REFCURSOR

Thank you,
Suresh

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we commit in trigger?

952

Does sql*plus have a pl/sql engine?

1046

How to check if a column is nullable before setting to nullable?

1101

Which is better cte or subquery?

1012

How does sql profiler work?

995

What operating systems are supported by oracle sql developer?

936

Can variables be used in sql statements?

1012

What is cursor explain with example?

963

When is the explicit cursor used ?

1007

which types of join is used in sql widely? : Sql dba

966

how to return query output in html format? : Sql dba

1057

What are different functions in sql?

921

How does sql developer connect to oracle database?

982

What is crud stand for?

983

What is the difference between syntax error and runtime error?

1119