可通过正则截取实现,例如下图,将'1,2'字符串通过","截取,分为两行数据
Select Regexp_Substr('1,2', '[^,]+', 1, Level) As "SKU" From Dual Connect By Regexp_Substr('1,2', '[^,]+', 1, Level) Is Not Null