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
- 8125 Views
- IBM, I also Faced
- E-Mail Answers
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 is count(*) from po_vendors(any table)?
What are do's and dont's of Interface?
Which oracle apps version you are very confident in?
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
In hierarchical structure of a database? we have write query from where we should start?
What do you understand by concurrent programs?
How can we import the data into a database using sql * loader?
What are the different components of soa suite?
Do you know where we can check the status of po?
How is choreography different from orchestration?
In sequence i want to 11 and 15th values how we will write?
what is global tempory table?
please send me forms, xml pulisher questions,answers
what are the different transaction clauses in AR?
How can a process be deployed in soa?
