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 |
What is Overloading of procedures ?
What is acid property in a database?
what is oltp (online transaction processing)? : Sql dba
How do you exit in sql?
What is sql in oracle?
How do I start sql profiler?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Is sql sequential or random?
How can u find column name from a table which have max value in a row.( not max value)
How do you select unique values in sql?
what is a relationship and what are they? : Sql dba
What are the benefits of using PL/SQL packages?
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)