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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

discuss about myisam index statistics collection. : Sql dba

523


What is output spooling in sql*plus?

549


What are the usages of sql?

564


How do I run a sql script?

510


How do I enable sql encryption?

518






How do I trace sql profiler?

491


What is the largest value that can be stored in a byte data field?

518


What is database white box testing and black box testing?

634


Mention what does plv msg allows you to do?

662


What is group function in sql?

531


Does sql*plus also have a pl/sql engine?

558


Is sql dba a good career? : SQL DBA

529


difference between anonymous blocks and sub-programs.

621


Is sql a case sensitive language?

514


Is oracle sql free?

536