Answer Posted / srilakshmi paleti
1)Implicit cursor
2)Explicit Cursor
EXPLANATION OF
1)IMPLICIT CURSOR : When ever user performs any DML
operation automatically implicit cursors will raise. User
noneed to create,open,fetch,close the cursor.In PLSQL
select statement also it will work.
2)EXPLICIT CURSOR: User has to create,open,fetch and close
the cursor.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to drop an index?
What happens to the data files if a tablespace is dropped?
What is the difference between online and offline backups?
How do we get field details of a table?
What is a read write transaction in oracle?
How to convert dates to characters in oracle?
What is the scope of a local variable?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Please explain drop constraint oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to delete a user account in oracle?
What language does oracle use?
List the various oracle database objects?
Why is oracle used?
How to define a data source name (dsn) in odbc manager?