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
How to recover a dropped table in oracle?
How to rename a column in an existing table?
Explain coalesce function?
What is the disadvantage of User defind function?
What are the uses of synonyms?
How to count groups returned with the group by clause in oracle?
What privilege is needed for a user to create tables in oracle?
What is blob data type in oracle?
How to find out what oracle odbc drivers are installed?
What language does oracle use?
How to start a new transaction in oracle?
What is connection pool in oracle?
How to do paging with oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
