Oracle 유용 구분 정리 - PARTITION BY, START WITH...CONNECT BY PRIOR
아래와 같은 임시 테이블(임시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 ..
Programming/Database
2010. 4. 22. 16:35