Interested to Buy Any Domain ? << Click Here >> for more details...
State the difference between implict and explict cursor's?
- 7 Answers
- 23121 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 mutating error?
Which are the different case manipulation functions in sql?
Define join and name different types of joins?
Why commit is not used in triggers?
Is primary key an index?
Why sql query is slow?
explain the difference between bool, tinyint and bit. : Sql dba
Explain the significance of the & and && operators in pl sql.
What is function and procedure in pl sql?
What is record data type?
How do I sort a table in sql?
How to know the last executed procedure?
How do you pronounce sql?
What is interval partition?
What is sql in java?
