Dynamic column in update statment....Is it possible ?
Dynamic column in update statment....Is it possible ?
My table
CREATE TABLE LOADING_PAPER ( EMP_CODE NUMBER(5), ITEM_CODE1 VARCHAR2(20),CRT1 NUMBER(10),PCS1 NUMBER(10), ITEM_CODE2 VARCHAR2(20),CRT2 NUMBER(10),PCS2 NUMBER(10), ITEM_CODE3 VARCHAR2(20),CRT3 NUMBER(10),PCS3 NUMBER(10), ITEM_CODE4 VARCHAR2(20),CRT4 NUMBER(10),PCS4 NUMBER(10), ITEM_CODE5 VARCHAR2(20),CRT5 NUMBER(10),PCS5 NUMBER(10), ITEM_CODE6 VARCHAR2(20),CRT6 NUMBER(10),PCS6 NUMBER(10), ITEM_CODE7 VARCHAR2(20),CRT7 NUMBER(10),PCS7 NUMBER(10), ITEM_CODE8 VARCHAR2(20),CRT8 NUMBER(10),PCS8 NUMBER(10), ITEM_CODE9 VARCHAR2(20),CRT9 NUMBER(10),PCS9 NUMBER(10), ITEM_CODE10 VARCHAR2(20),CRT10 NUMBER(10),PCS10 NUMBER(10))
icd := 1
for rec in c1 loop
update loading_paper
set 'item_code'||icd = rec.item_code,
0