Interested to Buy Any Domain ? << Click Here >> for more details...
Types of cursors and explanation each of them ?
- 4 Answers
- 13001 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 how exception handling is done in advance pl/sql?
Can you have more than one key in a database?
Can we use view in stored procedure?
Why join is faster than subquery?
How to run sql statements through the web interface?
What is sql profiling in oracle?
Which language is used in sql?
Explain what is a column in a table?
What are expressions?
What is composite data type in pl sql?
What is a sql profiler?
What is left inner join in sql?
what are the differences between char and varchar? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
What is an oracle stored procedure?
