What cursor type do you use to retrieve multiple recordsets?
Answers were Sorted based on User's Feedback
Answer / guest
cursor <<cursorname>> is select * from <<table name>>
Is This Answer Correct ? | 55 Yes | 16 No |
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 |
Answer / venkat
using explict cursor we process multiple rows
syn:
cursor <cur_name> is select * from <tab_name>
Is This Answer Correct ? | 3 Yes | 0 No |
Can you sum a count in sql?
Is delete faster than truncate?
What is the default isolation level in sql server? : Transact sql
i want to display 1 to 10 numbers using one select statement.
18 Answers HCL, Nyros, Oracle,
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.
What does “select count(*) from tab” result?
15 Answers IBM, Student, Wipro,
What does truncate mean in sql?
what are the features and advantages of object-oriented programming? : Sql dba
Who developed sql?
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
Is postgresql a server?
Explain UNION,MINUS,UNION ALL, INTERSECT?