split column value with ',' : INSTR « Char Functions « Oracle PL / SQL
split column value with ',' SQL> SQL> CREATE TABLE old_item ( 2 item_id CHAR(20), 3 item_desc CHAR(25) 4 ); Table created. SQL> SQL> INSERT INTO old_item VALUES('LA-101', 'Can, Small'); 1 row created. SQL> INSERT INTO old_item ......