By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table atable( doj date ) ;
alter table atable
add (
doc date
, constraint checkdoc check( doc > doj )
);
-- must succeed
insert into atable( doj, doc ) values ( sysdate, sysdate + 1 );
1 rows affected
-- must fail due to CHECK constraint
insert into atable( doj, doc ) values ( sysdate + 1, sysdate ) ;
ORA-02290: check constraint (FIDDLE_NCCPDWRNFEQUYMBQMCEZ.CHECKDOC) violated
select * from atable ;
| DOJ | DOC |
|---|---|
| 03-JUN-20 | 04-JUN-20 |