--order 502628      
      /*
      CHANGE REPORT for Table SUPPLIER
          - Adding column DATEACTIVE
          - Adding column DATEINACTIVE
      ACTION is ALTER or modify Table SUPPLIER
      */


ALTER TABLE SUPPLIER ADD (DATEACTIVE           DATE DEFAULT 
    sysdate NOT NULL);


ALTER TABLE SUPPLIER ADD (DATEINACTIVE         DATE DEFAULT 
    TO_DATE('31-12-2099','DD-MM-YYYY') NOT NULL);

update supplier s set s.dateactive = to_date('01-01-2000','dd-mm-yyyy');

commit;

