목록connect by prior (1)

not set

오라클 세로를 가로로 만들기

select 컬럼 , ltrim(sys_connect_by_path(컬럼,','),',') as 컬럼명 from ( select 컬럼 , menurole_id , row_number() over (partition by 그룹컬럼 order by 정렬할컬럼) rn , count (*) over (partition by 그룹컬럼 ) cnt from 테이블명 ) a where level = cnt start with rn = 1 connect by prior 그룹컬럼 = 그룹컬럼 and prior rn = rn-1 ============================================================= CONSRSEQTRADENMRNKCNT 0A건설(50)15 0B건설(15)25 0C건설..
Database/query 2011. 10. 4. 10:45