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
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......