Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursor?where are they used?
- 2 Answers
- 6535 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sohini
Whenever you issue a SQL statement, the Oracle server opens
a SQL work area in memory in which the command is parsed
and executed. This area is called a cursor.There are two
type of cursors:
Implicit Cursor:PL/SQL declares a cursor implicitly for all
SQL data manipulation statements, including queries that
return only one row.PL/SQL manages this cursorautomatically.
Explicit Cursor:The programmer explicitly declares and
names an explicit cursor for queries that return more than
one row.it is managed by the programmer.
Explicit cursors are used when one wants to do some
processing with a set of rows fetched from a table or
multiple table.They are managed using OPEN,FETCH and CLOSE.
4 attributes are used in both types of cursors:%FOUND,%
NOTFOUND,%ROWCOUNT and %ISOPEN.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
How to connect ms access to oracle servers?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain oracle left join with an example?
How to use null as conditions in oracle?
How to select the name of employee who is getting maximum sal with out using subquery
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are the type of Synonyms?
What is save point in oracle database?
What are the different types of synonyms?
What is different types of joins?
Oracle General 
