Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE  TABLE T (Da DATE  not null);
INSERT INTO T VALUES (TO_DATE('12/12/2022 0830','DD/MM/YYYY HH24MI'));
1 rows affected

select * from t;


DA


12-DEC-22


alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
select * from t;


DA


2022-12-12 08:30:00


create trigger tgbi_check_da
before insert on t
for each row
begin
    If (:new.Da <= sysdate)
    then Raise_Application_Error (-20000, 'Da column is inferior or equal to current datetime.');
    end if;
end;
/
INSERT INTO T VALUES (TO_DATE('01/12/2022 0830','DD/MM/YYYY HH24MI'));
ORA-20000: Da column is inferior or equal to current datetime.
ORA-06512: at "FIDDLE_EDJDZQQYAFCPFKRSWVHJ.TGBI_CHECK_DA", line 3
ORA-04088: error during execution of trigger 'FIDDLE_EDJDZQQYAFCPFKRSWVHJ.TGBI_CHECK_DA'

INSERT INTO T VALUES (TO_DATE('15/12/2022 0830','DD/MM/YYYY HH24MI'));
1 rows affected

select * from t;


DA


2022-12-12 08:30:00

2022-12-15 08:30:00