Interested to Buy Any Domain ? << Click Here >> for more details...
What is implicity cursor . When it fires . For which
statement it will fire(Insert/update/delte).
What is the attribute of implicity and explicity cursor
oracle 9i.
What is the Rec cursor.
- 2 Answers
- 8238 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
oracle automatically creates area for DML operations
programmer ill not have control for this cursor.
%found,%notfound,%rowcount,%isopen
Explicit cursor is user has to declare and open and
fetch for DML sql statment into this cursor explicit cursor
attributes are
sql%found,sql%notfound,sql%rowcount,sql%isopen
refcursor is datatype,a variable created based on such a
datatype is generally called cursor variable associated
with different queries at run-time.,by using this variable
capability to pass result sets between subprograms.
| Is This Answer Correct ? | 3 Yes | 0 No |
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
Can you have two functions with the same name in a pl/sql block?
while doing the process of conversion if got any data error out what is the next step to reprocess
While running the concurrent program we will get the status, we have to change the status. How it will be done.
How to link between inventory and OrderManagement.
What repots or concurrent program run to transfer data from Inventory to GL.
Give a brief overview on OrderManagement.
What are the Standard Reports and Forms in HRMS?
how many groups we can create for query?
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
Tell me some interface tables on ordermangement.
Oracle Apps Technical 
