Untitled

create or replace trigger mark_check
    before delete on students
    for each row
  declare
    c number:=120;
  begin
    if :old.marks > c then
       raise_application_error(-20002, 'Maximun mark exceeded');
    end if;
  end;
/