Interested to Buy Any Domain ? << Click Here >> for more details...
Types of cursors and explanation each of them ?
- 4 Answers
- 12567 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / giri
Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.sql%found,sql%notfound,sql%is open,sql%count these are the implicit cursor attributes.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.%found,%notfound,%is open,%count these are the explicit cursor attributes.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain ttitle and btitle.
how to drop an existing table in mysql? : Sql dba
How can we store rows in PL/SQL using array?
How to fix oracle error ora-00942: table or view does not exist
What are the types of variables use in pl sql?
Write the command to remove all players named sachin from the players table.
What is an exception in pl/sql?
What is a ddl command?
What is sql resultset?
How do you add a column to a table?
What is %type in pl sql?
What is the maximum number of rows in sql table?
Why is a trigger used?
Can we use having without group by in sql?
What is sql mysql pl sql oracle?
