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

oracle·ÖÒ³¾ÍÓÃÕâÒ»¾ä

·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ­×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *  
  from (SELECT AA.*, ROWNUM RN  
          from (SELECT * from USERS ORDER BY ID DESC) AA)  
 WHERE RN > 0 AND RN <= 10
 
˵Ã÷£º
ÆäÖÐUSERSΪÊý¾Ý¿â±íÃû
SELECT * from USERS ORDER BY ID DESC
ÕâÒ»¾äÊDz»½øÐзÖÒ³µÄ²éѯ¡£
¶øROWNUM <= 10ºÍRN >0ÓÃÓÚ¿ØÖÆÃ¿Ò³ÒªÏÔʾµÄÊý¾ÝÌõÊý£¬ÎÒÕâÀïÓÃROWNUM <= 10ºÍRN >0±íʾÿҳÏÔʾ10ÌõÊý¾Ý£¬ÄÇôҪ½øÈëÏÂÒ»Ò³£¬ÔòROWNUM <= 20ºÍRN >10
ÉÏÃæµÄÕâÁ½¸öÊýÖµÖ»ÐèÒªÄãÔÚ³ÌÐòÖж¯Ì¬´«ÈëÖµ£¬ÀýÈçÔÚstruts»òservletÖж¯Ì¬´«ÈëÁ½¸ö²ÎÊý¾Í¿ÉÒÔ½øÐзÖÒ³¿ØÖÆ¡£
MSSQL SYBASEÏÂÃæÓÃtop À´·ÖÒ³
POSTGRESQL MYSQL¾ÍÖ±½ÓÓÃlimit¸ü¼òµ¥ÁË
ÔÚoracle ÏÂÃæÓÐ4ÖÖ·½·¨
oracle·ÖÒ³¼¼Êõ2007Äê08ÔÂ13ÈÕ ÐÇÆÚÒ» 23:08Á½ÖÖ·ÖÒ³¼¼Êõ£¬µÚ¶þÖÖЧÂʸ߶àÁË
1. select * from
    (select rownum rn,t.* from table t )
    where rn <50 and rn>=1
2. select * from
    (select rownum rn,t.* from table t rownum<50)
    where rn>=1
´øÅÅÐòÒªÇóµÄ·ÖÒ³£¬ÔÚ9iÒÔÉϵĻ·¾³ÍƼöʹÓ÷ÖÎöº¯Êý
select * from
(select row_number() over(order by esn) rn,esn,akey from as_esn_info )
where rn <50 and rn>=1
£¨ÒÔÉÏ·½·¨ÑéÖ¤¹ý£©
»òÕßÒÔÏÂ
£¨1£©minus²î·ÖÒ³ £ºselect * from table where rownum<=10 minus select * from table where rownum<=5
£¨2£©rownumαÁзÖÒ³ £ºselect * from (select rownum tid,t.* from table t  where rownum<=10) where tid>5
£¨3£©notinÏà·´·ÖÒ³£ºselect * from table where id not in(select id from table where rownum<=5) and rownum<=5


Ïà¹ØÎĵµ£º

oracleÌåϵ½á¹¹¶þÖ®±í¿Õ¼ä¡¢·½°¸¡¢¶Î¡¢Çø¡¢¿é

     Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÊÇÊý¾Ý¿âÖÐ×îÖØÒªµÄÎļþ¡£ËüÃÇÊÇÊý¾Ý´æ´¢µÄµØ·½¡£Ã¿¸öÊý¾Ý¿âÖÁÉÙÓÐÒ»¸öÓëÖ®Ïà¹ØµÄÊý¾ÝÎļþ£¬Í¨³£Çé¿öϲ»Ö»Ò»¸ö£¬ÓкܶࡣÊý¾ÝÔÚÊý¾ÝÎļþÖÐÊÇÈçºÎ×éÖ¯µÄ£¿ÒªÁ˽âÕâЩÄÚÈÝÎÒÃÇÊ×ÏȱØÐëÀí½âʲôÊDZí¿Õ¼ä£¨tablespace£©¡¢¶Î£¨segment£©¡¢Çø£¨extent£©¡¢¿é£¨block£©£¬ÕâЩ¶¼ÊÇoracl ......

oracleÈÕÆÚ´¦ÀíÍêÈ«°æ(×ªÔØ)

TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar
month spelled out march
Year:
yy two digits 98
yyyy four digits 1998
24Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 0:00:00 - 23:59:59....
12Сʱ¸ ......

oracle ÈçºÎ°ÑÊý¾Ý¿â±äΪ·Ç¹éµµÈÕ־ģʽ

shutdown immediate
Ç¿Áв»½¨ÒéתΪ·Ç¹éµµÄ£Ê½
startup mount
alter database noarchivelog
alter database open
·Ç¹éµµ×ª¹éµµ
startup mount
alter database archivelog
alter database open
Ôڹ鵵ÈÕ־ģʽÏ£¬ÓпÉÄÜ»áÓöµ½¹éµµÈÕÖ¾´óС³¬¹ý×î´óÖµ¶ø³öÏÖÌÖÑáµÄORA-00257´íÎó£¬Ç°ÃæËµÁËÈçºÎ°Ñ¹éµµÈÕÖ¾¿Õ¼ä±ä´ó¡£¶ ......

oracle lockmode

ORACLEÀïËøÓÐÒÔϼ¸ÖÖģʽ:
0£ºnone
1£ºnull ¿Õ
e.g. 1¼¶ËøÓУºSelect£¬ÓÐʱ»áÔÚv$locked_object³öÏÖ¡£
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share 
     e.g. 2¼¶ËøÓУºSelect for update,Lock For Update,Lock Row Share 
   ......

Oracle Silent Installations(¾²Ä¬°²×°)


 
Linux Æ½Ì¨ÏÂOracle Silent Installations(¾²Ä¬°²×°)£¬Ò»Ö±¶¼Ã»Óг¢ÊÔ¹ýÓÃÕâÖÖ·½·¨À´×°Êý¾Ý¿â¡£ ÒòΪÓи߼¶µÄ¹¤¾ß£¬¾ÍûÓбØÒªÔÚÀ´ÓÃÕâÖÖ·½·¨ÁË£¬Oracle µÄ½çÃæ»¹ÊDZȽϷ½±ã£¬¶øÇÒÎÒÃÇ»¹ÓÐXmanager ¹¤¾ß£¬ËùÒÔÔÚlinux ÏÂ×°Èí¼þ£¬»¹ÊǺܷ½±ãµÄ¡£
 
Òò´ËÒ²¾ÍûÓÐÌ«ÔÚÒâÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ