What is difference between cursor and ref cursor?
- 1 Answers
- 973 Views
- I also Faced
- E-Mail Answers
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 'mysqlcheck'? : Sql dba
What are the components of a PL/SQL block ?
what are integrity rules?
There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?
Is sql scripting language?
What is oracle pl sql developer?
What is the difference between the conventional and direct path loads? : aql loader
Why is theta join required?
Where is all the data on the internet stored?
How do you update a value in sql?
How can you load microsoft excel data into oracle? : aql loader
how are rank and dense rank being alloted for column with same values over a particular column
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
