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 scope and visibility in PL/SQL?
Can ddl statements be used in pl/sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can we use update in sql function?
What are primary key and foreign key and how they work?
What do you understand by pl/sql packages?
What is difference between db2 and sql?
What are the advantages of sql? Explain
what are aggregate and scalar functions? : Sql dba
how does a local variable is defined using t-sql? : Transact sql
How do I make sql search faster?
How to create a menu in sqlplus or pl/sql?
What is pessimistic concurrency control? : Transact sql
What is type and rowtype in pl sql?
What is a record in pl/sql?