--Order 20011492.80


-------Modify COCNUMBER field in CUSTOMER table------

ALTER TRIGGER CUSTOMER_CHECK_CONTRACT_USAGE DISABLE;

ALTER TABLE CUSTOMER ADD ( TEMP_COCNUMBER NUMBER DEFAULT 0 NOT NULL );


UPDATE CUSTOMER C SET C.TEMP_COCNUMBER = C.COCNUMBER;
commit;


ALTER TABLE CUSTOMER DROP COLUMN COCNUMBER;


ALTER TABLE CUSTOMER ADD ( COCNUMBER VARCHAR2(20) DEFAULT 0 NOT NULL );


UPDATE CUSTOMER C SET C.COCNUMBER = C.TEMP_COCNUMBER;
commit;


ALTER TABLE CUSTOMER DROP COLUMN TEMP_COCNUMBER;


-------Modify PNNUMBER field in CUSTOMER table------

ALTER TABLE CUSTOMER ADD ( TEMP_PNNUMBER NUMBER DEFAULT 0 NOT NULL );


UPDATE CUSTOMER C SET C.TEMP_PNNUMBER = C.PNNUMBER;
commit;


ALTER TABLE CUSTOMER DROP COLUMN PNNUMBER;


ALTER TABLE CUSTOMER ADD ( PNNUMBER VARCHAR2(20) DEFAULT 0 NOT NULL );


UPDATE CUSTOMER C SET C.PNNUMBER = C.TEMP_PNNUMBER;
commit;


ALTER TABLE CUSTOMER DROP COLUMN TEMP_PNNUMBER;

ALTER TRIGGER CUSTOMER_CHECK_CONTRACT_USAGE ENABLE;   
