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

What is keys and its types?

534


Why we use sql profiler?

558


What are primary key and foreign key and how they work?

545


What is sqlerrm?

540


What is the difference between a subquery and a join?

523






What are the different types of dbms?

547


How to Execute a Package in PL/SQL.?

576


What does subquery mean in sql?

534


Why partition by is used in sql?

550


What is the use of procedures?

537


How do I add a database to sql?

570


How to return multiple rows from the stored procedure?

514


When should I use nosql database?

549


What packages are available to pl/sql developers?

592


what is denormalization. : Sql dba

538