What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 65903 Views
- Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sri
This ans opt for Oracle DB
---------------------------
SYS_REFCURSOR. this is what we called Explicit cursor.
In database if u run any sql statement by default system
will create a cursor. its called "Implicit cursor".
But in PL/SQL, we r using SYS_REFCURSOR to manupulate the
multiple records. that is called Explicit cursor.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
How is use pl and sql?
how does a local variable is defined using t-sql? : Transact sql
What is the difference between nested table and varray?
Why we use pl sql?
What is sqlexception in java?
when is the use of update_statistics command? : Sql dba
What are the benefits of stored procedures?
what is single byte over head in oracle..?
how can we know the count/number of elements of an array? : Sql dba
What are the events on which a database trigger can be based?
How does sql store data?
What is the use of index in hive?
How to use distinct and count in sql query? Explain
What is pl sql in oracle?
What are all the ddl commands?
