When you want to create a lov
with use where condition
Just use property plate of lov.
Use trigger against:
Lov with item;
Trigger name :
when-mouse-doubleclick with item Level trigger;
Syntax: if show_lov(‘lov_name’)
then
If
dup_detail_check(‘block_name.item_name’)=1 then
Msgbox(‘duplicate value’);
Clear_record;
End if;
End if;
POST-CHANGE trigger:
SELECT FIRST_NAME INTO :TEACHERS.FIRST_NAME
FROM TEACHERS
WHERE EMPLOYEE_ID = :TEACHERS.EMPLOYEE_ID;
EXCEPTION
...
Time in Dhaka 
