Check duplicate item in block item.

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

WHEN OTHERS THEN :TEACHERS.FIRST_NAME := NULL;