::: Zany's Homepage ::: Zany Wiki | »çÀÌÆ® ÅëÇÕ °Ë»ö
 
 
 

¹«ÇÑ ROW »ý¼º Äõ¸®

°Ô½ÃÆÇ
Oracle
ÀÛ¼ºÀÚ
Zany
ÀÛ¼ºÀÏ
2011-11-23 14:32:39
ÀÐÀº¼ö
3488
ÆòÁ¡
   
Ç¥½Ã¿É¼Ç
HTML»ç¿ë | ÀÚµ¿BRűנ| °ø¹é¹®ÀÚÇã¿ë | °¡¿îµ¥Á¤·Ä | °íÁ¤Æø±Û²Ã | ÀÚµ¿URL¸µÅ© | ¸¶¿ì½º¼±ÅÃ
°ü·Ã¸µÅ©01
http://kr.blog.yahoo.com/nwisio1450/128 
¹«ÇÑ·Î¿ì »ý¼º Äõ¸® ÀÔ´Ï´Ù.

Oracle 9i ÀÏ °æ¿ì
SQL>select * from
(select level from dual connect by level <= 10);

Oracle 10g ÀÏ °æ¿ì
SQL>select level from dual connect by level <= 10

¿øÇÏ´Â rows ¸¸Å­ level <= ? ¼ýÀÚ¸¦ ³Ö¾îÁÖ¼¼¿ä..

ÀÌ Äõ¸®´Â »ó´çÈ÷ À¯¿ëÇÕ´Ï´Ù. Áï ¿¹Àü¿¡ copy_t Å×À̺í·Î »ç¿ëÇÏ´ø

´Þ·ÂÅ×À̺íÀÌ´øÁö, Å×À̺íÀ» °¡°øÇÒ¶§ ÆíÇÕ´Ï´Ù.

´ÙÀ½ url Ŭ¸¯ÇϽøéÀº ¾î¶² ¿¹Á¦À϶§ ÁÁÀº°¡¿¡´ëÇÑ ±ÛÀÔ´Ï´Ù..

http://database.sarang.net/?inc=read&aid=24110&criteria=oracle&subcrit=qna&id=&limit=20&keyword=&page=7

°Ô½Ã¹°ÀÌ µµ¿òÀÌ µÇ¼ÌÀ¸¸é +1 À» ´­·¯ÁÖ¼¼¿ä~
 °Ô½ÃÆÇ ±Û ¸ñ·Ï
No Subject Poster Hits Posted
2649 Zany 5871 2011-11-23 20:33:09
Zany 3488 2011-11-23 14:32:39
2610 Zany 3807 2011-05-31 14:35:36
2595 Zany 6966 2011-03-31 13:12:45
2554 Zany 10301 2010-12-09 20:21:26
1876 Zany 4756 2009-04-20 15:59:49
1862 Zany 5829 2009-04-15 17:25:18
´ñ±Û ´Þ±â - ÀÌ ±ÛÀÌ µµ¿òÀÌ µÇ¾ú°Å³ª Èï¹Ì·Î¿ì¼Ì´Ù¸é, ´ñ±ÛÀ» ³²°ÜÁÖ¼¼¿ä.(^^)(oo)(__)
ÀÛ¼ºÀÚ
                       
 
zany.kr
  Copyright ¨Ï 2002-2010 Zany's Programming Lab. All Rights Not Reserved.
temporary This Page loads on 0.016 Secs