Table name: item_info
Colum_name:PRODUCTS_NAME
Code for duplicate data filter, for that you have to use Trigger-WHEN-VALIDATE-ITEM
Code:

declare

a number;

begin
select count(1) into a from item_info
where lower(PRODUCTS_NAME)=lower(:PRODUCTS_NAME);
if a>0 then
message(‘Already Exist In Database’);
message(‘Already Exist In Database’);
raise form_trigger_failure;
end if;
end;

Output:
WHEN-VALIDATE-ITEM

Suggested Posts:

Leave a Reply