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

oracleÊý¾Ý¿â´æ´¢

select * from test where rownum <=10 ÏÂÃæÊǹØÓÚrownumµÄ½éÉÜ ================================ RownumºÍrow_number() over()µÄʹÓà ROWNUMÊÇOracle´Ó8¿ªÊ¼ÌṩµÄÒ»¸öαÁУ¬ÊǰÑSQL³öÀ´µÄ½á¹û½øÐбàºÅ£¬Ê¼ÖÕ´Ó1¿ªÊ¼£¬³£¼ûµÄÓÃ;¾ÍÊÇÓÃÀ´·ÖÒ³Êä³ö. ±ÈÈç SELECT * from torderdetail a WHERE ROWNUM <= 10 ÕâÌõÓï¾ä¾ÍÊÇÊä³öǰ10Ìõ¼Í¼£¬ÔÚÕâÀïÓÃ;ÉÏÀàËÆÓÚsql severµÄtop£¬²»¹ýrownum¶ÔÓÚÖ¸¶¨±àºÅÇø¼äµÄÊä³öÓ¦¸Ã˵¸üÇ¿´ó SELECT * from (SELECT a.*, ROWNUM rn from torderdetail a) WHERE rn >= 10 AND rn <= 20 ÕâÌõÓï¾ä¼´ÊÇÊä³öµÚ10µ½µÚ20Ìõ¼Í¼£¬ÕâÀïÖ®ËùÒÔÓÃrownum rn£¬ÊǰÑrownumת³ÉʵÀý£¬ÒòΪrownum±¾ÉíÖ»ÄÜÓà <=µÄ±È½Ï·½Ê½£¬Ö»ÓÐת³ÉʵÁУ¬ÕâÑù¾Í¿É×ö >=µÄ±È½ÏÁË¡£ ÔÚʵ¼ÊÓÃ;ÖУ¬³£³£»áÒªÇóÈ¡×î½üµÄ¼¸Ìõ¼Í¼£¬Õâ¾ÍÐèÒªÏȶԼͼ½øÐÐÅÅÐòºóÔÙÈ¡rownum <= Ò»°ã³£¼ûµÄ SELECT * from (SELECT a.* from torderdetail a ORDER BY order_date DESC) WHERE ROWNUM <= 10 ¶øÔÚCSDNÔø¾­·¢Éú¹ýÌÖÂÛ£¬¹ØÓÚÈ¡½üµÄ10Ìõ¼Í¼£¬ÓÐÈ˸ø³öÕâÑùµÄÓï¾ä SELECT a.* from torderdetail a WHERE ROWNUM <= 10 ORDER BY order_date DESC Ö®ËùÒÔ»á³öÏÖÕâÑùµÄÓï¾ä£¬Ö÷ÒªÊÇ´ÓЧÂÊÉϵĿ¼ÂÇ£¬Ç°ÃæÌõÓï¾ä£¬ÊÇÒª½øÐÐÈ«±íɨÃèºóÔÙÅÅÐò£¬È»ºóÔÙÈ¡10Ìõ¼Í¼£¬ºóÒ»ÌõÓï¾äÔò²»»áÈ«±íɨÃ裬ֻ»áÈ¡³ö10Ìõ¼Í¼£¬ºÜÃ÷ÏÔºóÌõÓï¾äµÄЧÂÊ»á¸ßÐí¶à¡£ ÄÇΪʲô»áÓÐÕùÒéÄØ£¬ÄǾÍÔÚÓÚÔÚÖ´ÐÐ˳ÐòÉÏÕùÒ飬ÊÇÏÈÖ´ÐÐÅÅÐòÈ¡10Ìõ¼Í¼£¬»¹ÊÇÈ¡10Ìõ¼Í¼£¬ÔÙÅÅÐòÄØ£¿Á½ÖÖ˳ÐòÈ¡³öÀ´µÄ½á¹ûÊǽØÈ»Ïà·´µÄ£¬ÏÈÅÅÐòÔÙÈ¡10Ìõ£¬¾ÍÊÇÈ¡×î½üµÄ10Ìõ£¬¶øÏÈÈ¡10Ìõ£¬ÔÙÅÅÐò£¬ÔòÈ¡³öµÄ×îÔçµÄ10Ìõ¼Í¼¡£¶ÔÓÚ´ËÓï¾ä£¬ÆÕ±éµÄÈÏΪִÐÐ˳ÐòÊÇÏÈÈ¡10Ìõ¼Í¼ÔÙÅÅÐòµÄ¡£ËùÒÔ´ËÓï¾äÓ¦¸ÃÊÇ´íÎó¡£µ«Êµ¼ÊÉϲ¢·ÇÈç´Ë£¬´ËÓï¾äµÄÖ´ÐÐ˳ÐòºÍorder byµÄ×Ö¶ÎÓйØÏµ£¬Èç¹ûÄãorder by µÄ×Ö¶ÎÊÇpk£¬ÔòÊÇÏÈÅÅÐò£¬ÔÙÈ¡10Ìõ£¨ËٶȱȵÚÒ»ÖÖÓï¾ä¿ì£©£¬¶øÅÅÐò×ֶβ»ÊÇPK ʱ£¬ÊÇÏÈÈ¡10ÌõÔÙÅÅÐò£¬´Ëʱ½á¹û¾ÍÓëÒªÇó²»Ò»ÑùÁË£¬ËùÒÔµÚ¶þÖÖд·¨Ò»¶¨ÒªÔÚÅÅÐò×Ö¶ÎÊÇÖ÷¼üµÄÇé¿öϲÅÄܱ£Ö¤½á¹ûÕýÈ·¡£ Row_number() over()Õâ¸ö·ÖÎöº¯ÊýÊÇ´Ó9I¿ªÊ¼ÌṩµÄ£¬Ò»°ãµÄÓÃ;ºÍrownum²î²»¶à¡£ Ò»°ãд·¨row_number() over( order by order_date desc) Éú³ÉµÄ˳ÐòºÍrownumµÄÓï¾äÒ»Ñù£¬Ð§ÂÊÒ²Ò»Ñù£¨¶ÔÓÚͬÑùÓÐorder by µÄrownumÓï¾äÀ´Ëµ£©£¬ËùÒÔÔÚÕâÖÖÇé¿öÏÂÁ½ÖÖÓ÷¨ÊÇÒ»ÑùµÄ¡£ ¶ø¶ÔÓÚ·Ö×éºóÈ¡×î½üµÄ10Ìõ¼Í¼£¬ÔòÊÇrownumÎÞ·¨ÊµÏֵģ¬ÕâʱֻÓÐ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ÓÃradiusºÍoracle×öÈÏÖ¤¼Æ·Ñϵͳ


Redhat
as4 + oracle 10g(10.2.0)
+ freeradius1.1.2+ tomcat5.5
*****************************
±¾ÎÄĿ¼
********************************
Ò»¡¢°²×°
redhat as4
¶þ¡¢°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
   
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
£¨¶þ£©ÉèÖÃϵͳ²ÎÊ ......

Ò»¸öoracle SIDÅäÖÃÎÊÌâµÄ´¦Àí

ORA-24324: δ³õʼ»¯·þÎñ¾ä±ú
ORA-01041: ÄÚ²¿´íÎó, hostdef À©Õ¹Ãû²»´æÔÚ
¿´ÁËÒÔÏÂÎÄÕ£¬ÔòÐ޸쬵«Ð޸ĺóÎÞ·¨Æô¶¯listener£¬ÓÚÊÇÏëµ½ÔÚnet assistanceÖÐÐ޸ģ¬Íê³É£º
ÅäÖÃΪÒÔϲÅÄÜÕýÈ·Æô¶¯listener£º
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (S ......

LEI Á¬½ÓORACLE °æ±¾ÎÊÌâ

Can you connect to an Oracle database with a 64-bit Oracle client?
 Technote (FAQ)
 
 
 
Question
You are unable to connect to an Oracle database with a 64-bit Oracle client. Does Lotus Enterprise Integrator (LEI), Lotus Domino Enterprise Connection Services (DECS), or LSX ......

oracleÀ䱸·Ý »Ö¸´

·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
±¸·Ý£º
  Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔ­À´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔ­À´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ