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 |
What is exit statement?
What is trigger explain it?
What is dynamic SQl and how you will create and execute dynamic sql?
Can unique keys be null?
Is sql open source?
Which is better cte or subquery?
What are the differences between in and exists clause?
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
what are properties of a transaction? : Sql dba
What are the main features of cursor?
Does execute immediate commit?
Explain UNION,MINUS,UNION ALL, INTERSECT?
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)