--i-test 5 for order 502640

ALTER TABLE STERILIZATIONRUN RENAME COLUMN CHARGENUMBER TO CHARGENUMBER1; 

ALTER TABLE STERILIZATIONRUN ADD (CHARGENUMBER VARCHAR2(15) DEFAULT ' ' NOT NULL);

UPDATE STERILIZATIONRUN SET CHARGENUMBER = CHARGENUMBER1;

commit;

ALTER TABLE STERILIZATIONRUN DROP COLUMN CHARGENUMBER1;