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 |
If the base table structure is changed what will happen to join index????
Tell me what a package consists of.
Explain the two type of Cursors ?
Why is a primary key important?
Why stored procedures are faster than query?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
What is varchar data type in sql?
Is coalesce faster than isnull?
Is sql low level language?
What is compute?
how to include numeric values in sql statements? : Sql dba
Can primary key be changed?
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)