What does a COMMIT statement do to a CURSOR?
- 1 Answers
- 21282 Views
- Microsoft, Oracle, I also Faced
- E-Mail Answers
Answer / sandeep
a commit stmt in cursor will free the memory area(handle)
which is being used by the cursor.
| Is This Answer Correct ? | 57 Yes | 10 No |
What is dbms introduction?
What is database write application of database?
Can you copy the PROGRAM UNIT into an Object group ?
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
Operators used in select statements are?
Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.
Why dbms is used?
What are the basic elements of Base configuration of an oracle Database ?
HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.
what is the location of oracle inventory?
Differentiate nested loop, hash join and merge join.
Define scalar functions.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
