Interested to Buy Any Domain ? << Click Here >> for more details...
State the difference between implict and explict cursor's?
- 7 Answers
- 22853 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 a view? : Sql dba
What is sqlerrm?
What are the types of triggers in sql?
What is the maximum number of rows in sql table?
how can you see all indexes defined for a table? : Sql dba
What does count (*) mean in sql?
What is rownum?
How can I change database name in sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is a null value?
What is the difference between having clause and where clause?
what are integrity rules?
How do I start sql profiler?
How do I count records in sql?
What are local and global variables and their differences?
