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
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
ABOUT IDENTITY?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is a proxy object?
How to list all user accounts in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What are the different windows events activated at runtime ?
What is recovery manager(rman) backup in Oracle?
Where is the export dump file located?
Can we create database in oracle using command line ?
What is raw datatype?
How a database is related to tablespaces?
Explain oracle insert into command?
What is a sub query? What are its various types?
what's query optimization and without use of IN AND Exist can we get another way data from query