Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OracleÖÐΪʲôwhere rownum > 3 ²éÕÒ²»µ½Êý¾Ý£¿

²éѯ±íempÖÐËùÓÐÊý¾Ý
select emp_id,rownum from emp
µÚÒ»²½£¬²éѯ½á¹û,rownum´ý¶¨
emp_id rownum
1         ?   1
2         ?   2
3         ?   3
4         ?
µÚ¶þ²½£¬ÏÖÔÚ¼ÙÉèÓÃrownum < 3µÄÌõ¼þÀ´¹ýÂË
µÚÒ»ÐУ¬rownum³õʼ·ÖÅäΪ1£¬Âú×ãrownum <3µÄÌõ¼þ£¬È»ºórownum¼Ó1
µÚ¶þÐУ¬rownumÏÖÔÚΪ2,Âú×ã < 3µÄÌõ¼þ,È»ºórownum¼Ó1
.....
µÚ¶þ²½£¬ÏÖÔÚ¼ÙÉèÓà rownum > 2µÄÌõ¼þÀ´¹ýÂË
ÏÖÔÚ¿´µÚÒ»ÐУ¬rownum³õʼ·ÖÅäΪ1£¬ ²»Âú×ãrownum>2µÄÌõ¼þ,rownum²»»á¼Ó1
µÚ¶þÐУ¬rownum»¹ÊÇ1£¬Í¬Ñù²»Âú×ã>2µÄÌõ¼þ
....
ËùÒÔ£¬×îºóµÄ²éѯ½á¹û£¬Ò»ÌõÊý¾ÝҲûÓÐ
Àý×Ó£¬È¡µÚ3Ðе¹µÚ5Ðе±Êý¾Ý
    select * from
               (select t.*,rwonum rn
              from emp t
               where rownum < 5 )
       where rn > 3


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

LinuxϵÄOracle 10g°²×°¼°ÅäÖÃ

Ò».×ÊÔ´ÐèÒª£º
ÖÁÉÙ1024 MBÎïÀíÄÚ´æ
1024£­2048 Ðè1.5±¶µÄ½»»¥¿Õ¼ä
2048£­8192 Ðè1±¶µÄ½»»¥¿Õ¼ä
8192£­ Ðè0.75±¶µÄ½»»¥¿Õ¼ä
ÖÁÉÙ400 MB /tmp ÁÙʱĿ¼¿Õ¼ä
oracleÈí¼þÐèÒª1.5 GB µ½ 3.5 GB ´ÅÅ̿ռä
ĬÈÏÊý¾Ý¿âÐèÒª1.2 GB
¶þ.²é¿´ÏµÍ³×ÊÔ´Ïà¹ØÓï ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Ê®Èý) Ë÷Òý

1.¸ÅÊö
Ë÷ÒýÊÇÓ¦ÓÃÉè¼ÆºÍ¿ª·¢µÄÒ»¸öÖØÒª·½Ãæ¡£Èç¹ûÓÐÌ«¶àµÄË÷Òý£¬DML µÄÐÔÄܾͻáÊܵ½Ó°Ïì¡£Èç¹ûË÷ÒýÌ«
ÉÙ£¬ÓÖ»áÓ°Ïì²éѯ£¨°üÀ¨²åÈë¡¢¸üкÍɾ³ý£©µÄÐÔÄÜ¡£ÒªÕÒµ½Ò»¸öºÏÊÊµÄÆ½ºâµã£¬Õâ¶ÔÓÚÓ¦ÓõÄÐÔÄÜÖÁ¹Ø
ÖØÒª¡£
ÎÒ³£³£·¢ÏÖ£¬ÈËÃÇÔÚÓ¦Óÿª·¢ÖÐ×ÜÊÇʺó²ÅÏëÆðË÷Òý¡£ÎÒ¼á³ÖÈÏΪÕâÊÇÒ»ÖÖ´íÎóµÄ×ö·¨¡£Èç¹ûÄãÖª
µÀÊý¾Ý½«ÈçºÎ ......

OracleÊý¾Ý¿â»¹Õæ²»ºÃÕû

´ÓÔÚLinuxÉϰ²×°Oracleµ½Í¶ÈëʹÓòż¸Ì죬Åöµ½µÄÎÊÌâ¾Í³É°ÙÉÏǧµÄ¡£ÔÚʹÓÿͻ§¶ËÁ¬½ÓÔ¶³ÌOracleÊý¾Ý¿â·þÎñÆ÷ʱ£¬³öÏÖÁËlistener refused the connection with the following error ora-12519 Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler foundThe Connection ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ