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 |
how tsql statements can be written and submitted to the database engine? : Transact sql
What is pl/sql language case sensitive?
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
in a package one procedure is wrong package shows valid or not
What is triggering circuit?
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
What company owns postgresql?
How do you know if a relationship is 2nf?
Explain the usage of WHERE CURRENT OF clause in cursors ?
What is a string data type in sql?
How to download oracle sql developer?
How many types of functions are there in sql?
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)