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
- 13087 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 union and union all keyword in sql and what are their differences?
which tcp/ip port does sql server run on? : Sql dba
How do I add a primary key to a table?
i have some prob lem to tell me about my self in interview first round ...
how to extract a unit value from a date and time? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
Why stored procedure is better than query?
Why do we use sqlite?
what is data manipulation language? : Sql dba
How to create your own reports in sql developer?
How to combine two stored procedures in sql?
What is sql used for?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
how does a local variable is defined using t-sql? : Transact sql
How is use pl and sql?
