10g에서 sys_connect_by_path 사용법

create table temp_nation as select 'Seoul' city, 'Korea' country from dual union all select 'Busan' city, 'Korea' country from dual union all select 'Inchon' city, 'Korea' country from dual union all select 'LA' city, 'America' country from dual union all select 'Newyork' city, 'America' country from dual union all select 'Mexicocity' city, 'Mexico' country from dual ; select country, substr(max..

2011.12.01