Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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

Can function be overload?

4 Answers  


What is the concept of soa governance?

0 Answers  


Give a brief overview on OrderManagement.

1 Answers   Zensar,


please explain open interface import

2 Answers  


A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

0 Answers   Accenture,


what are the pl/sql tables

1 Answers   IBM,


what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,


which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,


Tell me how to debug the report?

0 Answers  


Presently u are working in which version?

4 Answers   Accenture,


what is the invoice matching

2 Answers  


What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,


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)