¹ØÓÚ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¡¡ Î
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......