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 a unique key ? : Sql dba
how to include comments in sql statements? : Sql dba
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.
what is meant by forward declaration in functions?
What is the difference between nested table and varray?
Can you sum a count in sql?
What is Raise_application_error ?
What if we write return in procedure?
What do you understand by pl/sql records?
What is difference between a PROCEDURE & FUNCTION ?
What is sequence in sql?
Is sql considered coding?
Oracle (3253)
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)