Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why is oracle so popular?
what is the scripts in data base?
What is system tablespace?
Can we insert data in view oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to compare dates in oracle sql?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Design database draw er diagram for a certain scenario ?
what is port in oracle? how is it related to database application.
What is the usage of synonyms?
what are archived logs?
What are the ansi data types supported in oracle?
Where do you use decode and case statements?
What is the Tune Query
How to define an explicit cursor in oracle?
