What is difference between cursor and ref cursor?
Answer / kiran r
Cursor is is pointer which is used access data retrived from database.Cursor is static in nature
ref cursor is datatype variable. whose memory address is working area query in database. it is dynamic in nature and it can be modified at the runtime
| Is This Answer Correct ? | 0 Yes | 0 No |
Is sql developer case sensitive?
what is the difference between trigger and storedprocedures
How to avoid using cursors?
What is sql server and ase?
How does a trigger work?
what are the forced views
What does t sql mean?
What is the use of nvl function?
What is extent clause in table space?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is sqlite format?
What is difference between % ROWTYPE and TYPE RECORD ?
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)