ALTER TABLE CONSTDEMONEW.DWH_TRAN_LOAD MODIFY REF_ID VARCHAR2(12) 
 
UPDATE CONSTDEMONEW.DWH_TRAN_LOAD SET REF_ID = TRIM(REF_ID) 
 
ALTER TABLE CONSTDEMONEW.DWH_TRAN_LOAD MODIFY REF_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY BU_CODE__O VARCHAR2(10) 
 
UPDATE CONSTDEMONEW.EMPLOYEE_DET_CHANGE SET BU_CODE__O = TRIM(BU_CODE__O) 
 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY BU_CODE__O CHAR(5)  
ALTER TABLE CONSTDEMONEW.ENTITY_CONTACT MODIFY CONTACT_PERS VARCHAR2(60) 
 
UPDATE CONSTDEMONEW.ENTITY_CONTACT SET CONTACT_PERS = TRIM(CONTACT_PERS) 
 
ALTER TABLE CONSTDEMONEW.ENTITY_CONTACT MODIFY CONTACT_PERS VARCHAR2(35)  
ALTER TABLE CONSTDEMONEW.GSTRECO_TRACE MODIFY TRAN_ID VARCHAR2(15) 
 
UPDATE CONSTDEMONEW.GSTRECO_TRACE SET TRAN_ID = TRIM(TRAN_ID) 
 
ALTER TABLE CONSTDEMONEW.GSTRECO_TRACE MODIFY TRAN_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.GSTRECO_TRACE MODIFY TRAN_ID__GSTN VARCHAR2(15) 
 
UPDATE CONSTDEMONEW.GSTRECO_TRACE SET TRAN_ID__GSTN = TRIM(TRAN_ID__GSTN) 
 
ALTER TABLE CONSTDEMONEW.GSTRECO_TRACE MODIFY TRAN_ID__GSTN CHAR(10)  
ALTER TABLE CONSTDEMONEW.HTL_BILL MODIFY CCTR_CODE__EXP VARCHAR2(10) 
 
UPDATE CONSTDEMONEW.HTL_BILL SET CCTR_CODE__EXP = TRIM(CCTR_CODE__EXP) 
 
ALTER TABLE CONSTDEMONEW.HTL_BILL MODIFY CCTR_CODE__EXP CHAR(4)  
ALTER TABLE CONSTDEMONEW.HTL_BOOK MODIFY CCTR_CODE__EXP VARCHAR2(10) 
 
UPDATE CONSTDEMONEW.HTL_BOOK SET CCTR_CODE__EXP = TRIM(CCTR_CODE__EXP) 
 
ALTER TABLE CONSTDEMONEW.HTL_BOOK MODIFY CCTR_CODE__EXP CHAR(4)  
ALTER TABLE CONSTDEMONEW.HTL_BOOK_AMD MODIFY CCTR_CODE__EXP VARCHAR2(10) 
 
UPDATE CONSTDEMONEW.HTL_BOOK_AMD SET CCTR_CODE__EXP = TRIM(CCTR_CODE__EXP) 
 
ALTER TABLE CONSTDEMONEW.HTL_BOOK_AMD MODIFY CCTR_CODE__EXP CHAR(4)  
ALTER TABLE CONSTDEMONEW.HTL_BOOK_AMD MODIFY CCTR_CODE__EXP_O VARCHAR2(10) 
 
UPDATE CONSTDEMONEW.HTL_BOOK_AMD SET CCTR_CODE__EXP_O = TRIM(CCTR_CODE__EXP_O) 
 
ALTER TABLE CONSTDEMONEW.HTL_BOOK_AMD MODIFY CCTR_CODE__EXP_O CHAR(4)  
ALTER TABLE CONSTDEMONEW.OPPR_ASSESMENT MODIFY STAGE_CODE VARCHAR2(5) 
 
UPDATE CONSTDEMONEW.OPPR_ASSESMENT SET STAGE_CODE = TRIM(STAGE_CODE) 
 
ALTER TABLE CONSTDEMONEW.OPPR_ASSESMENT MODIFY STAGE_CODE CHAR(3)  
ALTER TABLE CONSTDEMONEW.PAYABLES_DTL MODIFY REF_NO VARCHAR2(15) 
 
UPDATE CONSTDEMONEW.PAYABLES_DTL SET REF_NO = TRIM(REF_NO) 
 
ALTER TABLE CONSTDEMONEW.PAYABLES_DTL MODIFY REF_NO CHAR(12)  
ALTER TABLE CONSTDEMONEW.PRJCUSTOMER MODIFY MODULE_CODE VARCHAR2(10) 
 
UPDATE CONSTDEMONEW.PRJCUSTOMER SET MODULE_CODE = TRIM(MODULE_CODE) 
 
ALTER TABLE CONSTDEMONEW.PRJCUSTOMER MODIFY MODULE_CODE CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.RECEIVABLES_DTL MODIFY REF_NO VARCHAR2(15) 
 
UPDATE CONSTDEMONEW.RECEIVABLES_DTL SET REF_NO = TRIM(REF_NO) 
 
ALTER TABLE CONSTDEMONEW.RECEIVABLES_DTL MODIFY REF_NO CHAR(10)  
ALTER TABLE CONSTDEMONEW.STOCK_EXTRA MODIFY BATCH_NO VARCHAR2(50) 
 
UPDATE CONSTDEMONEW.STOCK_EXTRA SET BATCH_NO = TRIM(BATCH_NO) 
 
ALTER TABLE CONSTDEMONEW.STOCK_EXTRA MODIFY BATCH_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.STOCK_EXTRA MODIFY LOT_SL VARCHAR2(15) 
 
UPDATE CONSTDEMONEW.STOCK_EXTRA SET LOT_SL = TRIM(LOT_SL) 
 
ALTER TABLE CONSTDEMONEW.STOCK_EXTRA MODIFY LOT_SL CHAR(5)  

-- No of Rows = 45
