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.
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 |
What and Who is the best Institute or Trainer for Oracle Apps Technical ?
explain p2p cycle? what are the tables used for this?
What are the validations you don in .CTL file in inbound interface process?
How will U link GL with OU in Multi-org environment.
In xml report, how to print the headings in every page?
How You Will display the key flexifields in your report
Attribute data types?
can we use look up type instead of a pofile option?or valueset?is it possible how?
how to set org context?
where to define interorganization transaction charges and what are the different options?
where we find the status of order information.
Which one Module is Biggest Module in oracle apps?