거꾸로 토마토

이전에 유용 구분이라고 작성한 내용을 해석해 보겠다. 우선 기본이 되는 table이 있어야 하는데 없으니까 view를 생성하는 부분이 다음과 같다. WITH TVIEW AS ( SELECT 'a' AS ac , '1a' AS acv FROM dual UNION ALL SELECT 'a' AS ac , '3a' AS acv FROM dual UNION ALL SELECT 'e' AS ac , '2e' AS acv FROM dual UNION ALL SELECT 'a' AS ac , '4a' AS acv FROM dual UNION ALL SELECT 'b' AS ac , '1b' AS acv FROM dual UNION ALL SELECT 'c' AS ac , '1c' AS acv FROM dual UNI..

아래와 같은 임시 테이블(임시VIEW)의 정보를 하나의 ac에 대해서 속해있는 acv 값을 하나의 string로 나열하기. WITH TVIEW AS ( SELECT 'a' AS ac , '1a' AS acv FROM dual UNION ALL SELECT 'a' AS ac , '3a' AS acv FROM dual UNION ALL SELECT 'e' AS ac , '2e' AS acv FROM dual UNION ALL SELECT 'a' AS ac , '4a' AS acv FROM dual UNION ALL SELECT 'b' AS ac , '1b' AS acv FROM dual UNION ALL SELECT 'c' AS ac , '1c' AS acv FROM dual UNION ALL SELECT ..