how a reference cursor works?what all adnvantages are
gained with it..specify the situation?
- 4 Answers
- 13404 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 your daily office routine?
what is sql server agent? : Sql dba
Can we rollback truncate?
If a cursor is open, how can we find in a pl/sql block?
what are aggregate and scalar functions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what is bcp? When does it used? : Sql dba
Can we use distinct and group by together?
Can delete statement be rollbacked?
what is dbms? : Sql dba
define sql insert statement ? : Sql dba
Is primary key always clustered index?
Do we need to rebuild index after truncate?
what is collation? : Sql dba
How do I remove duplicates in two columns?
