how a reference cursor works?what all adnvantages are
gained with it..specify the situation?
Answer Posted / narendrareddy
Generally, through static cursors we are using only one select statement at a time for single active set area. Whereas, in ref cursor we are executing number of select statements dynamically for single active set area. That’s why these types of cursors are called dynamic cursors.
1) Strong Ref Cursor: Having return type.
2) Weak Ref Cursor: Does not have return type.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are different types of sql?
What is the use of count (*) in sql?
Why do we use function in pl sql?
What is the use of desc in sql?
Can we rename a column in the output of sql query?
What is an alias command?
Define the select into statement.
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Is sql developer case sensitive?
What are different types of triggers?
Can I learn sql in a week?
Explain autonomous transaction.
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Is mariadb a nosql database?
what is table? : Sql dba