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
What is user managed backup in Oracle?
How to define a specific record type?
What do you understand by a database object?
what are actual and formal parameters?
How to concatenate two text values in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How many categories of data types in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What is background process in Oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the limitations of check constraint?
How to put more than 1000 values into an oracle in clause?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is a relational database management system?