What is implicity cursor . When it fires . For which statement it will fire(In

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.

Question Posted / debasis

2 Answers
7996 Views
IBM, I also Faced
E-Mail Answers

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,

For more Oracle Apps Technical Interview Questions Click Here