why we use cursors
Answer / pallavi
cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within sql statement
| Is This Answer Correct ? | 1 Yes | 2 No |
what is ora 600?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
What types of replication are supported in sql server? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How can we know the exact updation date of a particular database?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you get actual data change values from previous transactions in oracle?
what is the use of ocr?
In oracle 10g export, import if we declare rows=y/n what would be the output?
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)