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

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

658


What is sorting in sql?

496


Is left join same as inner join?

525


How many types of keys are there in sql?

546


Why is stored procedure faster than query?

482






Why query optimization is needed?

507


How to handle bulk data?

885


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

538


What is difference between nchar and nvarchar?

532


Why is a primary key important?

537


Can a table contain multiple foreign key’s?

554


What do you mean by rowid?

528


differentiate between float and double. : Sql dba

549


What is the difference between nested table and varray?

510


What does trigger mean in psychology?

528