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
Explain user account with reference to oracle.
What is the fastest query method to fetch data from the table?
How to convert character types to numeric types?
Query to retrieve record for a many to many relationship ?
what are archived logs?
How to insert a record into a table?
How to connect to the server with user account: sys?
What is an oracle database?
How translate command is different from replace?
Is the After report trigger fired if the report execution fails ?
How to delete all rows a table in oracle?
Explain the use of indexes option in imp command.
WHAT IS ecc 6.0
List the types of joins used in writing subqueries?
What is where clause in oracle?