Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
how to join query for one source type is oracle another source type is sql server ?
How do we get field details of a table?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to open a cursor variable?
What is pragma autonomous transaction in oracle?
What is program global area (pga) in oracle?
How to assign values to data fields in record variables?
What is execute immediate in oracle?
Is java required for oracle client?
How to save query output to a local file?
How to write a left outer join with the where clause in oracle?
How to use fetch statement in a loop?
What is a named program unit?
What is max rowid in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
