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 |
Explain the usage of WHERE CURRENT OF clause in cursors ?
what is innodb? : Sql dba
How do you use a while loop in pl sql?
How can I pass the inner procedure value to outer procedure ?
how to use case expression? : Sql dba
Explain the order of sql statement execution?
How do I count rows in sql query?
Can pl sql procedure have a return statement?
What is the diffrence between IN and EXISTS.which one is faster.
What is the difference between a primary key and a clustered index?
What is the use of index in hive?
How do I edit a stored procedure?
Oracle (3259)
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)