Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table shots (
  name varchar(30),
  x number,
  y number
);
create or replace trigger delet_shot
    before INSERT on shots
for each row
begin
    if (:new.x > 120) then
        raise_application_error(-20000, 'Стрелок не попал в мишень');
    end if;
end;
/
insert into shots (name, x, y)
  select 'Bill', 12, 61 from dual union all
  select 'Marat', 150, 85 from dual union all
  select 'Ivan', 18, 13 from dual
;
ORA-20000: ?????????????? ???? ?????????? ?? ????????????
ORA-06512: at "FIDDLE_WSQHZTNMTOGKECZXMKVE.DELET_SHOT", line 3
ORA-04088: error during execution of trigger 'FIDDLE_WSQHZTNMTOGKECZXMKVE.DELET_SHOT'

select * from shots;