State the difference between implict and explict cursor's?
- 7 Answers
- 21712 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 the purpose of the sql select top clause?
What is the difference between mdf and ndf files?
What is raid? How does it help storage of databases?
What is the purpose of the partition table?
Why are indexes and views important to an organization?
What is offset in sql query?
what is the difference difference between procedure and packages
List out the acid properties and explain?
Explain the uses of database trigger.
what is the bond code in materialized view?
is mysql query is case sensitive? : Sql dba
how to do backup entire database? : Transact sql
How do I tune a sql query?
What are types of indexes in sql?
What is t sql in sql server?
