i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify?
Answers were Sorted based on User's Feedback
Answer / sureshkumar somayajula
Hi ,
It will use in PL/SQL. Reusability of Cursor is nothing
but "REF CURSOR".These are of 2 types.
1. Weak Ref cursor 2. Strong ref Cursor.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / raghu
Ref cursor comes in PL/SQL.
You can return a ref cursor in a function.
A ref cursor is useful while returning more values.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / murali
ref cursor is of pl/sql topic
the main use of Ref Cursor is we can create multiple activeset area using refcursors
| Is This Answer Correct ? | 1 Yes | 0 No |
Why does sql need a server?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
Explain exception handling in pl/sql?
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
What are all the different normalizations?
What is the difference between instead of trigger and after trigger?
What is the difference between clustered and non-clustered indexes?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
What is the Subquery?
How can you create Cursor with parametres ?
while loading data into database how can u skip header and footer records in sql*loader
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)