Tuesday, June 19, 2018

Example of Unnamed system Exception. (Give Example of Check constraint violation) - DBMS (Exception)


declare
checkinc exception;
pragma exception_init(checkinc, -02290);
begin
insert into student values('3','Raj','efgh','65000');
exception
when checkinc then
dbms_output.put_line('Too much Income');
end;

No comments:

Post a Comment