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 |
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
what are the different types of parameters avialable in reports?
In xml report, how to print the headings in every page?
about TCA architecture
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what is latest version in reports
what is the defference between credit memo and debit memo
what is the differences between internal requisition and internal sales order?
why we can use synonym?
we have 4 managers if one person logon the system automatically displays his siganature and name how?
Can we create tables in apps schema?
what is difference between d2k report and oracle apps report