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
How to run queries on external tables?
What is a subquery in oracle?
Who developed oracle & when?
How do I uninstall oracle client from windows?
How to write numeric literals in oracle?
How can you use check constraints for self referential integrity?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are the uses of Database Trigger ?
In the oracle version 9.3.0.5.0, what does each number shows?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to get a list of all background sessions in the database?
what is Single Byte Overhead...?
What is a nvl function? How can it be used?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Explain a synonym?