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.
Answer Posted / venkatesh
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 |
Post New Answer View All Answers
What do you understand by soa?
Are you familiar with internet architecture of oracle apps 11i?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
q)what are the validations in sql*loader
How to move the one file from one instance to another instance? And your scripts also?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
is it possible to run the interface without using oracle apps?
how do you describe O2C along with tables
In oracle application how do you debug or trace errors?
can we get profile values in report without using user exists is it possible how?
what is the differences between internal requisition and internal sales order?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
what is global tempory table?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP