Re: I need help with if statement in my trigger statement
Can't rollback from a Trigger. Try ...
if exists(select 1 from customers where `Last Name`=new.`Last Name`) then
SIGNAL sqlstate '45001' set message_text = 'Customer name exists";
end if;
Also, do not create table or column names with spaces in them, and do not proper case such names.
Subject
Views
Written By
Posted
558
June 27, 2022 02:56PM
Re: I need help with if statement in my trigger statement
322
June 28, 2022 07:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.