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
- 12933 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 a database? : Sql dba
How do I add a database to sql?
Is coalesce faster than isnull?
What is trigger explain with example?
How to start oracle sql developer?
How many types of cursors supported in pl/sql?
Why do we use subquery?
What is sql basics?
How do you modify a column in sql?
Define tables and fields in a database
What is natural join in sql?
What does varchar include?
What is normalisation in sql?
explain the difference between bool, tinyint and bit. : Sql dba
What are the 3 modes of parameter?
