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 dml and ddl?
How is data stored in sql?
What are the different ddl commands in sql?
What are pl/sql cursors?
Can you have more than one key in a database?
define sql delete statement ? : Sql dba
Why self join is used in sql?
what is self-join? : Sql dba
How are functions and procedures called in PL/SQL?
how to convert character strings to numeric values? : Sql dba
Explain ttitle and btitle.
Explain the difference between sql and mysql.
What does closing a cursor do?
How to get help at the sql prompt?
Does truncate free space?