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

¹ØÓÚoracle rownumµÄÒ»¸ösqlÓï¾ä¡£¡£ - Oracle / ¿ª·¢

¿´ÏÂÃæsqlÓï¾ä£¬ÎÒÏëÓà rw À´ÊµÏÖ´Ón-mµÄ½ØÈ¡
select * from(select times,pages,rownum rw from layouts) where times='20090105' order by pages asc;

½á¹ûÊÇ£º
 times pages rw
20090105 A001 96
20090105 A002 97
20090105 A003 98
.
.

Ϊʲôrw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿ÒÔÖÁÓÚÎÒÔÚwhereºóÃæÓà rw>=10 and rw<=20µÄʱºòûÓÐÖµ¡£¡£¡£
½âÎö:
1¡¢¡°ÎªÊ²Ã´rw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿¡±
select times,pages,rownum rw from layouts
³öÀ´µÄ½á¹û¼¯Ò»¶¨ÊÇ
 times pages rw
XXXXXXXX XXXX 1
XXXXXXXX XXXX 2
XXXXXXXX XXXX 3
...
20090105 A001 96
20090105 A002 97
20090105 A003 98
...

È»ºóÄãÔÙtimes='20090105',½á¹û¼¯ÀïÃærwµ±È»Ö»ÓÐÊÇÂú×ãÌõ¼þµÄ½á¹ûÁË¡£

2¡¢¡°ÒÔÖÁÓÚÎÒÔÚwhereºóÃæÓà rw>=10 and rw<=20µÄʱºòûÓÐÖµ¡±
Õâ¸öÐÞ¸Äһϣ¬½«times='20090105'·Åµ½×Ó²éѯÖоͿÉÒÔÁË¡£
select * from(select times,pages,rownum rw from layouts where times='20090105') 

Ï£Íû¶ÔÄãÓÐËù°ïÖú

ÒòΪÕâÀï°´pagesÅÅÐòÁË£¬ËùÒÔrw²¢²»ÊÇ´Ó1¿ªÊ¼£¬rownumÊÇÔÚorderby֮ǰ¸³ÓèµÄαÁÐ

ÎÒÒ²¸ã²»ÇåÂ¥Ö÷×´¿ö£¬ ÊÇÏñÂ¥ÉÏ1¡¢Àï˵µÄÂð£¿

ÒýÓÃ

½âÎö:
1¡¢¡°ÎªÊ²Ã´rw²»ÊÇ´Ó1¿ªÊ¼µÄ£¿¡±
select times,pages,rownum rw from layouts
³öÀ´µÄ½á¹û¼¯Ò»¶¨ÊÇ
times pages rw
XXXXXXXX XXXX 1
XXXXXXXX XXXX 2
XXXXXXXX XXXX 3
...
20090105 A001 96
20090105 A002 97
20090105 A00¡­¡­

Î


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ