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

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ÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

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 / ¿ª·¢

SQL code:

CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......

linux ·þÎñÆ÷ °ó¶¨ÓòÃû - Web ¿ª·¢ / Ó¦Ó÷þÎñÆ÷

ÎÒÂòÁËÒ»¸ö¶ÀÁ¢·þÎñÆ÷ Óй̶¨IP ²¢ÇÒÓòÃûÒ²ÒѾ­½âÎöµ½ÏàÓ¦µÄIPÉÏÁË
ͨ¹ýF-Secure SSH Ò²ÒѾ­Á¬ÉÏ·þÎñÆ÷ ¹Ø¼ü²»»áÈ÷þÎñÆ÷°ó¶¨ÉÏÏàÓ¦µÄÓòÃû û·¨·ÃÎÊ
Ҳͨ¹ýÍøÉÏÏà¹Ø½Ì³ÌÊÔÁË ¿ÉÊÇûÓà ÆäÖÐÒ»¸öÏà¶ÔȫһµãµÄ½Ì³Ì
h ......

oracleÁ½¸öÊý¾Ý¿âµÄͬ²½£¿ - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿

ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ