Untitled

create or replace trigger dob_check
    before insert on students
    for each row
  begin
    if :new.dob > sysdate then
       raise_application_error(-20001, 'Person can not be born in the future');
    end if;
end;
/