Dear all,
10.2.0.5 on solaris 10
We inserted 20,000 rows in a table
INSERT INTO STOCKS (WH_CODE, BIN_ID, ITEM_CODE, GRN_NO, ITEM_NO, PACK_NO, QTY_ON_HAND, USED_QTY, SELLING_PRICE, STATUS,W_STATUS, CHANGE_DATE, ENTRY_DATE, OP_ID, QTY_RECVD, ITEM_ID, LOST_QTY, CURRENT_ACTION, ITEM_COST, SUBSCR_TYPE, AREA,flex_fld1) values ('WH01', 'BIN1', 'SC01', 0, ' 040105240040', '0', 1, 0, 0, 'DEFINED', 'OPEN', sysdate, sysdate, 'TABSK', 0, ITEM_ID.NEXTVAL, 0, 'IDLE', 0, 'G', '0','GET IT THRU MANAGED SERVCIES1 29MAYY2012'); commit;
the above statement inserted values, but there is a space in the column ITEM_NO
' 040105240040' . I need to change/update all this colummns to rmeove the space and updated as '040105240040' (with out space before 040)
Please advise
Kai