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

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

2227