What is a REF CURSOR? Compare strong and week ref cursor types.

Answer Posted / sure

ref cursor is a datatype we can assign variables that data type called cursor variable,cursor variable can associate with different queries at run time,primary advantage of refcursor is we can pass result set morethan one sub program

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do sql triggers work?

544


How do I edit a trigger in sql developer?

532


what is an alias command? : Sql dba

539


What is a data manipulation language?

567


What is the difference between unique and primary key constraints?

582






How do you delete a table?

528


Is sql procedural language?

546


Can we use two order by clause in query?

539


What is synonyms?

566


What is a temporal data type?

587


Does truncate require commit?

533


Describe sql comments?

551


What are commit, rollback, and savepoint?

565


Why cross join is used?

622


What does dml mean?

538