Interested to Buy Any Domain ? << Click Here >> for more details...
how a reference cursor works?what all adnvantages are
gained with it..specify the situation?
- 4 Answers
- 13273 Views
- TCS, I also Faced
- E-Mail Answers
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 is join view in sql?
What are %type and %rowtype for?
Can a key be both primary and foreign?
What is the difference between execution of triggers and stored procedures?
How can we avoid duplicating records in a query?
What is the difference between null value, zero, and blank space?
Is the primary key an index?
What is an index in sql with example?
what is a stored procedure? : Sql dba
What is trigger types of trigger?
Does sql use python?
what is acid property in database? : Sql dba
What are the query optimization techniques?
Why do we use sql constraints?
Why do we need a foreign key?
