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
- 6995 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 |
After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?
Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?
what is the difference between character mode,bitmap mode
2 Answers IBM, Sierra Atlantica,
How do u customize the Reports?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
what is the database size you used?
What are do's and dont's of Interface?
how can we get odd numbered pages in output of a report
How is choreography different from orchestration?
cursor 1 and cursor 2 are there did you open both the cursors at a time or not?
Can 2 functions have same name & input parameters but differ only by return datatype ?
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?
Oracle Apps Technical 
