데이타가
1 한나라
1_1 ㄷ
1_2 ㄴ
1_3 ㄹ
1_4 ㄱ
2 민주당
2_1 ㄹ
2_2 ㄴ
2_3 ㄷ
2_4 ㄱ
3 국민당
3_1 ㄷ
3_2 ㄹ
3_3 ㄴ
3_4 ㄱ
이렇게 있습니다
이것을
이렇게 하고 싶습니다...
좀 알려 주심 감사하겠습니다.
with tmp as ( select '1 한나라' aa from dual union all select '1_1 ㄷ' aa from dual union all select '1_2 ㄴ' aa from dual union all select '1_3 ㄹ' aa from dual union all select '1_4 ㄱ' aa from dual union all select '2 민주당' aa from dual union all select '2_1 ㄹ' aa from dual union all select '2_2 ㄴ' aa from dual union all select '2_3 ㄷ' aa from dual union all select '2_4 ㄱ' aa from dual union all select '3 국민당' aa from dual union all select '3_1 ㄷ' aa from dual union all select '3_2 ㄹ' aa from dual union all select '3_3 ㄴ' aa from dual union all select '3_4 ㄱ' aa from dual ) select aa from tmp order by to_number(translate(substr(aa, 1, instr(replace(aa, ' ', '_'), '_')), ' _', '91')) desc, substr(aa, instr(aa, ' ')+1)