Answer Posted / ddpras
They are 4 Levels of triggers
Form Level
Block level
Record Level
Item Level
This is the prority of triggers.firing order like this Form
level,Block level,Record level then Item Level
If you want to validate the values of an Item, usually use
Item level trigger, such as POST-Test,Pre-Test,when-new-Item
trigger.
In Form Level triggers are When-new-form,pre-form,Post-form,
In Block level triggers are when-new-block,pre-block,post-block,
In Record Level triggers are when-new-record,pre-record and
Post-record
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
i am writing a query select EmpNo from Emp how can i call in after parameter form
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Is it possible to execute a dynamic sql from forms?
List the different types of columns in oracle reports.
What is an oracle report? List its various types.
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
What is an oracle report?
if some data is not transfered where it will get stored
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
In what sequence do triggers get fired by oracle forms?
Explain how one can iterate through items and records in a specified block?
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
how do u compile a form i.e .fmb file in Unix or in dos
can you convert or reverse engineer a fmx back to a fmb file?
all steps of bitmap report?