¹«ÇÑ·Î¿ì »ý¼º Äõ¸® ÀÔ´Ï´Ù.
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
|
|
|
 |
°Ô½ÃÆÇ ±Û ¸ñ·Ï |
|
No |
Subject |
Poster |
Hits |
Posted |
|
2649 |
|
helix |
6989 |
2011-11-23 20:33:09 |
|
 |
|
helix |
4171 |
2011-11-23 14:32:39 |
|
2610 |
|
helix |
4623 |
2011-05-31 14:35:36 |
|
2595 |
|
helix |
8151 |
2011-03-31 13:12:45 |
|
2554 |
|
helix |
11597 |
2010-12-09 20:21:26 |
|
1876 |
|
helix |
5471 |
2009-04-20 15:59:49 |
|
1862 |
|
helix |
6429 |
2009-04-15 17:25:18 |
|
|
 |
ÄÚ¸àÆ® |
|
|
|
|
|
|