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

What is the use of sqldataadapter?

975

What are the parts of a sql statement?

1090

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1193

Is record in pl sql?

975

What is rowid in sql?

987

How is indexing done in search engines?

982

Is inner join same as self join?

1117

What are the two types of exceptions.

1171

What is a table?

1016

What is left join in sql?

1051

what are all types of user defined functions? : Sql dba

1042

What is the difference between partitioning and sharding?

1008

How to fetch alternate records from a table?

1244

How to run sql statements with oracle sql developer?

1070

How do you break a loop in pl sql?

1050