linux Oracle ÏÂʹÓÃrownumºÜÂý - Oracle / ¿ª·¢
ÎÒÔÚLinuxÉÏ×°ÁËOracleÊý¾Ý¿â£¬ÆäÖÐÓÐÒ»¸ö±í£¬´óÔ¼ÓÐ90000ÌõÊý¾Ý£¬ÓÃOracle½øÐзÖÒ³²éѯµÄʱºò£¬·¢ÏÖºÜÂý
sqlÓï¾äÈçÏ£º
select *
from (select row_.*, rownum rownum_
from (select * from usercontract
order by CODE) row_)
where rownum_ <= 100
and rownum_ > 80
ÆäÖÐcode²»ÊÇÖ÷¼ü£¬µ«ÊÇÎÒ°´ÕÕcode½¨ÁËË÷Òý£¬
²éѯ´óÔ¼ÐèÒª7s£¬
¸÷λ¸ßÊÖÇë°ïæ·ÖÎöÒ»ÏÂ
Ö´Ðмƻ®ÊÇʲô£¿ÏÂÃæµÄд·¨¿ÉÒÔÉÙɨһ´Î£¬ÊÔÊÔ£º
SQL code:
select * from (
select rownum rn, t1.*
from usercontract t1
order by code) t2
where t2.rn between 80 and 100;
Ó¦¸Ã²»ÊÇROWNUMÔì³ÉµÄ£¬ÄãµÄÖ´Ðмƻ®¿´¿´Ôõô×ßµÄ
LZÇëÖØÐ·ÖÎöһϱíºÍ±àÒëË÷Òý£¬Èç¹ûÄãÊÇÔÚµ¼ÈëÊý¾Ýǰ´´½¨µÄË÷ÒýÐÅÏ¢£¬»òÕßË÷ÒýʱºÜ¾ÃÒÔǰ´´½¨µÄ£¬È»ºó³¢ÊÔÏÂһϷ½Ê½ÊÇ·ñºÃÓá£
Æä´Î£¬Çë³¢ÊÔһϼ¸ÖÖ·½Ê½£¬ÊÇ·ñ¿ÉÒÔÌá¸ßЧÂÊ
1¡¢¼ÙÈçÄã´´½¨µÄË÷ÒýÃû×Ö½Ð×ö:IDX_CONTRACT_CODE£¬ÄÇôÄãÕâÑù³¢ÊÔһϷ½·¨1£º
SQL code:
SELECT *
from (SELECT A.*, ROWNUM RN
from (SELECT /*+INDEX_ASC(t1,IDX_CONTRACT_CODE)*/*
from USERCONTRACT T1
ORDER BY CODE) A
WHERE ROWNUM <= 100)
WHERE RN >= 80
2¡¢·½·¨2£º
SQL cod
Ïà¹ØÎÊ´ð£º
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
ÎÒÂòÁËÒ»¸ö¶ÀÁ¢·þÎñÆ÷ Óй̶¨IP ²¢ÇÒÓòÃûÒ²ÒѾ½âÎöµ½ÏàÓ¦µÄIPÉÏÁË
ͨ¹ýF-Secure SSH Ò²ÒѾÁ¬ÉÏ·þÎñÆ÷ ¹Ø¼ü²»»áÈ÷þÎñÆ÷°ó¶¨ÉÏÏàÓ¦µÄÓòÃû û·¨·ÃÎÊ
Ҳͨ¹ýÍøÉÏÏà¹Ø½Ì³ÌÊÔÁË ¿ÉÊÇûÓà ÆäÖÐÒ»¸öÏà¶ÔȫһµãµÄ½Ì³Ì
h ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......