What are cursor?where are they used?
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 |
What is a package in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Explain what does a control file contain?
what are archived logs?
How does the on-delete-cascade statement work?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Explain oracle’s system global area (sga).
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
How to start instance with a minimal initialization parameter file?
What are the roles of dba?
how to truncate date and get only time part 9:20:00
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls