UPDATE OFFICE_ORDERS
SET WHO_DATE = SYSDATE
WHERE WHO_DATE NOT BETWEEN '01.01.1996' AND '01.01.2018';

TO_DATE(SYSDATE, 'DD/MM/YYYY')

UPDATE OFFICE_ORDERS
SET WHO_DATE = SYSDATE
WHERE WHO_DATE NOT BETWEEN '01.01.1996' AND '01.01.2018';

***...***
Delete From CustomsAdmin.OFFICE_ORDERS
Where DCUS_Code = 38 and
Type_Card = 1 and Num_Card = 62 and
Year_Card = 2017

***...***

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  DELETE OFFICE_ORDERS 
      1   TABLE ACCESS BY INDEX ROWID OFFICE_ORDERS 
      1    INDEX RANGE SCAN (ххххххххххх)

***...***

Insert Into CustomsAdmin.OFFICE_ORDERS
(DCUS_Code, Num_Card, Year_Card,
Who, Who_Date, For_Whom, For_Whom_Note, Order_Content, Order_Pos,
UserN) Values (:1, :2, :3,
:4, :5, :6, :7, :8, :9,
:10)
***...***

CREATE OR REPLACE TRIGGER CUSTOMS.update_invalid_time
BEFORE INSERT OR UPDATE
ON CUSTOMSADMIN.OFFICE_ORDERS
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
begin
	 if :new.who_date not between '01.01.2005' AND sysdate + 30 then :new.who_date := null;
end if;
end;
/

 DATE_MODIF WHO_DATE  
 ---------- ----------
 03.01.2012 21.11.8201
 25.12.2012 12.07.0201
 25.12.2012 15.07.0201
 21.11.2012 16.11.1201
 14.09.2012 14.09.0112
 18.09.2012 17.08.0912
 19.10.2012 18.10.8201

CREATE OR REPLACE TRIGGER CUSTOMS.update_invalid_time
BEFORE INSERT OR UPDATE
ON CUSTOMSADMIN.OFFICE_ORDERS
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
begin
	 if :new.who_date not between '01.01.2005' AND trunc(to_date(sysdate + interval '1' year),'YEAR') then :new.who_date := null;
end if;
end;
/

CREATE OR REPLACE TRIGGER CUSTOMSADMIN.update_invalid_time
BEFORE INSERT OR UPDATE
ON CUSTOMSADMIN.OFFICE_ORDERS
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
begin
	 if :new.who_date not between to_date('01.01.2005', 'dd.mm.yyyy') AND trunc(sysdate + 366) then :new.who_date := null;
end if;
end;
/

select add_months(trunc(sysdate,'year'),12) + 1 from dual;