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
How to Execute a Package in PL/SQL.?
how to use case expression? : Sql dba
Can we debug stored procedure?
What is null in pl/sql?
Explain scalar functions in sql?
What is the difference between an inner and outer join?
What are crud methods?
How do I quit sql?
Can sql developer connect to db2?
What is trigger in pl sql with examples?
Why do we need pl sql?
Why we use stored procedure instead of query?
Can we use delete in merge statement?
How to prepare for oracle pl sql certification?
What is crud diagram?