sal 3000 exception

PHOTO EMBED

Mon May 27 2024 02:58:35 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

declare 
   invalid_sal Exception;
   s employee.sal%type:=&sal;
begin 
   if (s<3000) then
     raise invalid_sal;
   else
     insert into employee(sal) values(s);
     dbms_output.put_line('Record inserted');
   end if;
Exception
      when invalid_sal then
           dbms_output.put_line('sal greater ');
end;
/
content_copyCOPY