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 rollback the current transaction in oracle?
What privilege is needed for a user to create tables in oracle?
Can I create users through internet explorer in oracle 10g?
What is the usage of synonyms?
How to name query output columns in oracle?
Why do you use stored procedures and state some of its disadvantages?
Explain the types of exception?
What is an oracle and why it is used?
How to convert characters to numbers in oracle?
Explain drop constraint oracle?
How to create a new tablespace in oracle?
How to connect to the server with user account: sys?
How to write a query with a right outer join in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Why packages are used in oracle?
