---------------------
´ëÇ¥ÀÌ»ç
Àλç±×·ì
-- ÀλçÆÀ
-- ÀλçÆÄÆ®
-- ±³À°ÆÄÆ®
-- Ãѹ«ÆÄÆ®
-- À繫ÆÀ
-- À繫ÆÄÆ®
-- ±¸¸ÅÆÄÆ®
---------------------------------------------------------------
±¸Çö Äõ¸®¹®
select
lpad('',(level-1)*2,' ')||sys_connect_by_path(deptname,'--') as "Á¶Á÷µµ"
from TABLE
start with dept = :dept /* ÃÖ»óÀ§Á¶Á÷ */
connect by prior dept = pDept
order siblings by dept