ALTER TABLE V000002604.GSTRECO_TRACE MODIFY TRAN_ID VARCHAR2(15) 
 
UPDATE V000002604.GSTRECO_TRACE SET TRAN_ID = TRIM(TRAN_ID) 
 
ALTER TABLE V000002604.GSTRECO_TRACE MODIFY TRAN_ID CHAR(10)  
ALTER TABLE V000002604.GSTRECO_TRACE MODIFY TRAN_ID__GSTN VARCHAR2(15) 
 
UPDATE V000002604.GSTRECO_TRACE SET TRAN_ID__GSTN = TRIM(TRAN_ID__GSTN) 
 
ALTER TABLE V000002604.GSTRECO_TRACE MODIFY TRAN_ID__GSTN CHAR(10)  

-- No of Rows = 6
