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
- 8152 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 |
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
Explain what are the tables of auto invoice?
IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?
Difference between Bind and Lexical parameters?
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
what are the balancing segments in AR?
what is the standard program for blanket po to process data from interface table to bace table
What does appl_top directory contain?
Difference between triggers and procedures?
Stored procedure?
q)what are the validations in sql*loader
How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
Oracle Apps Technical 
