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



What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). ..

Answer / guest

EVERY SQL STMT IMPLICITY OPENS ONE CURSOR AND PARSE AND
EXECUTE QUERY FOR EVER STMT IT WILL FIRE
IMPLIST
SQL%

Is This Answer Correct ?    6 Yes 0 No

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). ..

Answer / 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

More Oracle Apps Technical Interview Questions

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

0 Answers   IBM,


what are the different types of parameters avialable in reports?

2 Answers   Oracle,


In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,


about TCA architecture

1 Answers   TCS,


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

0 Answers   Satyam,






what is latest version in reports

8 Answers  


what is the defference between credit memo and debit memo

3 Answers   Wipro,


what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,


why we can use synonym?

6 Answers  


we have 4 managers if one person logon the system automatically displays his siganature and name how?

1 Answers   BirlaSoft,


Can we create tables in apps schema?

0 Answers  


what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)