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
How many row comparison operators are used while working with a subquery?
How to get list of all tables from a database?
What is the use of prepared statement?
Can we use commit inside a trigger?
tell us something about heap tables. : Sql dba
what is bcp? When does it used? : Sql dba
What is a column in a table?
write an sql query to find names of employee start with 'a'? : Sql dba
How long does it take to learn pl sql?
How many primary keys can a table have?
Is record in oracle pl sql?
Can you rollback after commit?
What does (+) mean in sql joins?
What is embedded sql with example?
Does truncate table reset auto increment?