Answer Posted / manvendra
USER DEFINED sql WORK AREA FOR QUERY IS CURSOR.
USED TO STORE RESULT SET PROVIDED BY THE QUERY FOR SHORT
AND TEMP BASIS.
MAIN STATES ARE
CLOSE
OPEN
FETCH
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Give the various exception types.
Please explain drop constraint oracle?
How to use an explicit cursor without open statements?
List the various oracle database objects?
How to connect the oracle server as sysdba?
What is the fastest query method to fetch data from the table?
How to apply filtering criteria at group level in oracle?
How to write a query with a right outer join in oracle?
How to drop an index?
What is an oracle?
How to define an anonymous block?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Explain an index?
What are the attributes that are found in a cursor?