Answer Posted / vipin kumar ( m.c.a)
Cursor is a private SQL work area to perform an action using
PL/SQL statement. DBA allocate the memory space to the
objects that is area is called the cursor.
Cursor has two types-
1. Implicit cursor:- means predefine cursor.
2. Explicit cursor:- means created by the user or programmer.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to rebuild an index in oracle?
How to save query output to a local file?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
State and explain the different types of data models?
Can you have more than one content canvas view attached with a window ?
How to use select statement to count the number of rows in oracle?
Why we use bulk collect in oracle?
Can we save images in a database and if yes, how?
What privilege is needed for a user to create views in oracle?
How many types of segments in Oracle?
Explain the use of tables option in exp command.
Give the constructs of a package, function or a procedure.
how to clone 9i Database on to 10g Database.
What is a trigger oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?