State the difference between implict and explict cursor's?
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 difference between microsoft access and sql?
What does partition by mean in sql?
what is data control language? : Sql dba
How do sql triggers work?
How long it takes to learn pl sql?
What is sql catalog?
how are mysql timestamps seen to a user? : Sql dba
What is the difference between instead of trigger and after trigger?
what is offset-fetch filter in tsql? : Transact sql
What is the difference between a database and a relational database?
how to shutdown mysql server? : Sql dba
Explain what is a view?
How to rename a table?
What is nvarchar max in sql?
Can we use ddl statements in stored procedure sql server?