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
What is keys and its types?
Why we use sql profiler?
What are primary key and foreign key and how they work?
What is sqlerrm?
What is the difference between a subquery and a join?
What are the different types of dbms?
How to Execute a Package in PL/SQL.?
What does subquery mean in sql?
Why partition by is used in sql?
What is the use of procedures?
How do I add a database to sql?
How to return multiple rows from the stored procedure?
When should I use nosql database?
What packages are available to pl/sql developers?
what is denormalization. : Sql dba