Interested to Buy Any Domain ? << Click Here >> for more details...
What cursor type do you use to retrieve multiple recordsets?
- 17 Answers
- 70778 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 to shut down the server with 'mysqladmin'? : Sql dba
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is spool?
Why do we use procedures in pl sql?
What is sqlservr exe?
what is “go” in t-sql? : Transact sql
What is sql basics?
Mention what is the use of function "module procedure" in pl/sql?
What is the best partition size for windows 10?
What is a primary key example?
what are the authentication modes in sql server? How can it be changed? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
Is primary key clustered or nonclustered?
how to drop an existing table in mysql? : Sql dba
What is a dynamic query?
