Interested to Buy Any Domain ? << Click Here >> for more details...
What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 69933 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
What program will open a mdb file?
What is a sql schema used for?
What is a recursive join sql?
What is meant by user defined function?
What are the popular database management systems in the it industry?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
i have some prob lem to tell me about my self in interview first round ...
How to set up sql*plus output format in oracle?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is the use of index in sql?
What is input buffer in sql*plus?
What is the basic structure of an sql?
what is the difference between myisam static and myisam dynamic? : Sql dba
Can there be 2 primary keys in a table?
Can we create table in function?
