拆解中括号中的字符串

SELECT REGEXP_SUBSTR(F.STORE_DESC, '[^,]+', 1, LEVEL) AS FILE_ONE, STORE_DESC,
       LEVEL,f.id
  FROM (SELECT substr(T.STORE_DESC,2,length(T.STORE_DESC)-2) STORE_DESC,id
           FROM PM_C_PROM_ACTI_STORE T where t.store_desc is not null and t.id=782943157345947648
         ) F 
  CONNECT BY LEVEL <=
                  (LENGTH(F.STORE_DESC) -
                  LENGTH(REGEXP_REPLACE(F.STORE_DESC, ',', '')) + 1)

 不能直接用表要套一个子查询，要不然Level默认从2开始