Question { Zensar, 13814 }

Can we customize a form with out template.fmb

Answer

yes we can customize form with custom.pll or
personalization
if u want to make any code changes that time we ill go for
custom.pll for backend
for small modificatios we can use only personalisation.on
front end.

Question { Zensar, 6944 }

Give a overview on Aol

Answer

AOL stands for Appilication Object Library and it ill hold
different kinds of executables and libraries by using this
libraries u can customize forms in oracle apps for example
custom.pll,
appcore like this files

Question { Oracle, 13896 }

Oder of firing triggers in form

Answer

while opening form
form lvevel -- block level -- item level triggers will fire
while closing form that time lowest level onwards triggers
will fire like

item level-- block level -- form level

Question { IBM, 6563 }

What is an Index , Types od index why we are use index.

Answer

Index is a performance tuning method by using this we can
retrive records fastly index types are

- unique index
- non unique index
- bitmap index
- B-tree index

Question { IBM, 6968 }

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

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.

Question { IBM, 25846 }

What is Pragma Autonomous transaction. It's Real time
Example

Answer

Pragma autonomous transaction is independent transaction
and mainly we can use this transaction in databsae triggers
to write TcL statments like commit,rollback.