Interested to Buy Any Domain ? << Click Here >> for more details...
State the difference between implict and explict cursor's?
- 7 Answers
- 23181 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / madhuri
The implicit cursor is used to process INSERT, UPDATE,
DELETE, and SELECT INTO statements. During the processing of
an implicit cursor,Oracle automatically performs the OPEN,
FETCH, and CLOSE operations.
Where as in explicit cursors,the process of its working is
done in 4 steps namely DECLARE a cursor,OPEN a cursor,
FETCH from cursor and CLOSE a cursor.
| Is This Answer Correct ? | 16 Yes | 6 No |
Post New Answer View All Answers
What is multiple partition?
What is the difference between a query and a report?
Explain the commit statement.
What do you understand by exception handling in pl/sql?
explain the difference between bool, tinyint and bit. : Sql dba
what happens if null values are involved in expressions? : Sql dba
what is the command line end user interface - mysql? : Sql dba
How to download oracle sql developer?
How do I filter in sql profiler?
What are the basic techniques of indexing?
What is sqlerrd?
What are the benefits of triggers?
what is the difference between blob and text? : Sql dba
What are different types of triggers?
Mention what does the hierarchical profiler does?
