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 are the benefits of using soa architecture?
Tell me how to find the custom directory in front end?
how do you describe O2C along with tables
How can you achieve loose coupling in soa framework?
What is oracle soa suite?
what is the differences between internal requisition and internal sales order?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what is global tempory table?
What are do's and dont's of Interface?
can we use look up type instead of a pofile option?or valueset?is it possible how?
testing tools?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Explain oracle apps architecture.
Explain what are the tables of auto invoice?
Which oracle apps version you are very confident in?