Recent Comments
- Today
- 3
- Total
- 229,838
Notice
목록피벗 (1)
개발은 너무해
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..
Oracle/Oracle Study
2011. 12. 1. 14:52