HOME   ·Î±×ÀΠ  ȸ¿ø°¡ÀÔ
    
ȸ¿ø°¡ÀÔ
ºñ¹Ð¹øÈ£ ã±â ÀÚµ¿·Î±ä
ÀÌÀü°Ô½ÃÆÇ
   free_board
   °Ç°­°Ô½ÃÆÇ
   ¿À¶óŬDB
   Linux
   HTML/javascript
   Áú¹®°ú ´ä
È£¼­±â
   À̹ÌÁö°Ô½ÃÆÇ  
   °Ç°­°Ô½ÃÆÇ  
   À½¾ÇÀÚ·á  
   ¼ºÁØÀÌ °Ô½ÃÆÇ  
[ÀϹÝ] [sql] ƯÀÌÇÑ Äõ¸®¹® ¿¹Á¦ °èÃþÀûÀ¸·Î Äõ¸®µ¥ÀÌÅÍ ÃßÃâ
  È£¼® ´Ô²²¼­ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 ÀÐÀ½:4880  

---------------------

´ëÇ¥ÀÌ»ç

Àλç±×·ì

-- ÀλçÆÀ

-- ÀλçÆÄÆ®

-- ±³À°ÆÄÆ®

-- Ãѹ«ÆÄÆ®

-- À繫ÆÀ

-- À繫ÆÄÆ®

-- ±¸¸ÅÆÄÆ®

---------------------------------------------------------------
±¸Çö Äõ¸®¹®

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
 


¸ñ·Ï

ºÐ·ù ¼±ÅÃ
50 ÀÏ¹Ý ORA-29532 xml ÆÄÀÏÇڵ鸵ÇÒ¶§ ±ÇÇÑÁÖ±â È£¼® 06-06-15 4889
ÀÏ¹Ý [sql] ƯÀÌÇÑ Äõ¸®¹® ¿¹Á¦ °èÃþÀûÀ¸·Î Äõ¸®µ¥ÀÌÅÍ ÃßÃâ È£¼® 06-06-14 4881
48 ÀÏ¹Ý [sql] Çѷο쿡 °°Àº ±×·ìµ¥ÀÌÅÍ ÃßÃâÇϱâ È£¼® 06-06-14 3655
47 ÀÏ¹Ý [sql]Æã¼ÇÀ̳ª ÇÁ·Î½ÃÁ® ÆÑÅ°Áö °°Àº ¸ñ·Ï º¸±â È£¼® 06-05-13 4125
46 ÀÏ¹Ý [sql]pakage ÆÐÅ°Áö ±¸Çö¿¹Á¦ (1) È£¼® 06-05-13 3570
45 ÀÏ¹Ý [sql trigger]Æ®¸®°Å ÀÛ¼º¿¹Á¦ È£¼® 06-05-01 4654
44 ÀÏ¹Ý [sql procedure]ÇÁ·Î½ÃÁ® ÀÛ¼º¿¹Á¦ È£¼® 06-05-01 4206
43 ÀÏ¹Ý [proc] proc Pro*C ¸®´ª½º¿¡¼­ ¼³Ä¡¹ý, ¼³Á¤, ÆÄÀÏÂüÁ¶ (1) È£¼® 06-04-28 5212
42 ÀÏ¹Ý ¿À¶óŬ 10g ¼³Ä¡ È£¼® 06-03-20 5486
41 ÀÏ¹Ý ¿À¶óŬ 10G ¼³Ä¡Çϱâ È£¼® 06-03-20 4927
40 ÀÏ¹Ý MySQL ¶óÀ̼¾½º Á¤Ã¥ È£¼® 06-03-17 4122
39 ÀÏ¹Ý [sql] Äõ¸®¿¹Á¦ ÇѲ¨¹ø¿¡ updatet Çϱâ (1) È£¼® 06-03-10 3553
38 ÀÏ¹Ý [sql] Äõ¸®¿¹Á¦ ÇѲ¨¹ø¿¡ insert Çϱâ È£¼® 06-03-09 3573
37 ÀÏ¹Ý export dump ¾ÈµÉ¶§ È£¼® 06-02-17 4295
  ÀÏ¹Ý    export dump ¾ÈµÉ¶§ È£¼® 06-02-20 5130
óÀ½ÀÌÀü  [1] [2] [3] [4] [5] [6] 7 [8] [9] [10]  ´ÙÀ½¸Ç³¡

 
Copyright © zenos.pe.kr. All rights reserved.