Tuesday, June 19, 2018

Using trigger provide check constraint on table Client(no, name, address, city). Note : no always start with capital letter ‘C’. - DBMS (Trigger)


create or replace trigger t5 before insert on empmaster
for each row
begin
if (:new.no not like ('c%'))then raise_application_error(-20001, 'table is secured ');
end if;
end;

No comments:

Post a Comment