예로들면, 'ACM,MANC,MANU,ASR' 문자열 데이터를

ACM
MANC
MANU
ASR
...

(이렇게 레코드 데이터로 변경하기 원할 때 유용하게 사용할 수 있다.)
        WITH TEAM AS (
            SELECT  'ACM,MANC,MANU,ASR' AS TEAM_C FROM DUAL UNION ALL
            SELECT  'KOR,JPN,CHN'       AS TEAM_C FROM DUAL
        )
        
        SELECT  REGEXP_SUBSTR(TEAM_C, '[^,]+', 1, LEVEL)                        AS TEAM_C
          FROM  (
                SELECT  LISTAGG(TEAM_C, ',') WITHIN GROUP (ORDER BY TEAM_C ASC) AS TEAM_C
                  FROM  TEAM
                )
    CONNECT BY  REGEXP_SUBSTR(TEAM_C, '[^,]+', 1, LEVEL) IS NOT NULL
      ORDER BY  TEAM_C ASC