sal_greater

PHOTO EMBED

Sat Jun 08 2024 02:29:50 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

declare 
   invalid_sal Exception;
   s employ.sal%type:=&sal;
begin 
   if (s<3000) then
     raise invalid_sal;
   else
     --insert into employ(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