level-3-support

ALTER TABLE HOUSEMANI_HEADER
ADD APPROVAL_DATE_DT DATE;
/
UPDATE HOUSEMANI_HEADER
SET APPROVAL_DATE_DT = TO_DATE(APPROVAL_DATE, 'DD-MON-YYYY HH24:MI')
WHERE APPROVAL_DATE IS NOT NULL
  AND APPROVAL_DATE_DT IS NULL;
/
COMMIT;
/
CREATE OR REPLACE TRIGGER TRG_HMH_APPROVAL_DATE_DT
BEFORE INSERT OR UPDATE OF APPROVAL_DATE, APPROVAL_DATE_DT
ON HOUSEMANI_HEADER
FOR EACH ROW
BEGIN
    IF :NEW.APPROVAL_DATE_DT IS NULL
       AND :NEW.APPROVAL_DATE IS NOT NULL
    THEN
        :NEW.APPROVAL_DATE_DT := TO_DATE(:NEW.APPROVAL_DATE, 'DD-MON-YYYY HH24:MI');
    END IF;
END;
/
CREATE INDEX IDX_HMH_APPROVAL_DATE_DT
ON HOUSEMANI_HEADER (APPROVAL_DATE_DT);
```