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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Redhat
as4 + oracle 10g(10.2.0)
+ freeradius1.1.2+ tomcat5.5
*****************************
±¾ÎÄĿ¼
********************************
Ò»¡¢°²×°
redhat as4
¶þ¡¢°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
£¨¶þ£©ÉèÖÃϵͳ²ÎÊ ......
ORA-24324: δ³õʼ»¯·þÎñ¾ä±ú
ORA-01041: ÄÚ²¿´íÎó, hostdef À©Õ¹Ãû²»´æÔÚ
¿´ÁËÒÔÏÂÎÄÕ£¬ÔòÐ޸쬵«Ð޸ĺóÎÞ·¨Æô¶¯listener£¬ÓÚÊÇÏëµ½ÔÚnet assistanceÖÐÐ޸ģ¬Íê³É£º
ÅäÖÃΪÒÔϲÅÄÜÕýÈ·Æô¶¯listener£º
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(S ......
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Ŀ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔÀ´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔÀ´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ ......