Oracle batch columns are separated by commas
Example:
With temp as (select'1 nums 2 nums,'a 'names from dual union all select' 4 names from dual union all select 5 nums, b 'names from dual union all select' 6 nums 7 'nums, c' names from dual union all select 8' nums, c 'names from dual union all select' 9 nums, c 'names from dual union all select' 11 nums) 'c 'names from dual union all select'13 nums,' 14 'nums,' c' names from dual union all select'15 16 'nums,' c' names from dual union all select'17 names from dual union all select 18 'nums,' c' names from dual union all select'19 20 'nums,' c' names from dual union all select'21, 22, 24, 24, 26, 28, 29, 30, 31, 31, 3, 34, nums,', names from dual) select regexp_substr (nums,' [^,] +', 1 B.lv) order_num,namesfrom temp, (select level lv from dual connect by level
