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
- 13138 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
Is full outer join same as cross join?
What is sql injection vulnerability?
What are dml commands?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is sharding in sql?
What is information schema in sql?
What is the difference between python and sql?
What does sign mean sql?
How many types of sql are there?
Where can I learn sql for free?
What are local and global variables and their differences?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is sap sql?
what is a join? : Sql dba
What is right join in sql?
