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

oracle·ÖÒ³¾ÍÓÃÕâÒ»¾ä

·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ­×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *  
  from (SELECT AA.*, ROWNUM RN  
          from (SELECT * from USERS ORDER BY ID DESC) AA)  
 WHERE RN > 0 AND RN <= 10
 
˵Ã÷£º
ÆäÖÐUSERSΪÊý¾Ý¿â±íÃû
SELECT * from USERS ORDER BY ID DESC
ÕâÒ»¾äÊDz»½øÐзÖÒ³µÄ²éѯ¡£
¶øROWNUM <= 10ºÍRN >0ÓÃÓÚ¿ØÖÆÃ¿Ò³ÒªÏÔʾµÄÊý¾ÝÌõÊý£¬ÎÒÕâÀïÓÃROWNUM <= 10ºÍRN >0±íʾÿҳÏÔʾ10ÌõÊý¾Ý£¬ÄÇôҪ½øÈëÏÂÒ»Ò³£¬ÔòROWNUM <= 20ºÍRN >10
ÉÏÃæµÄÕâÁ½¸öÊýÖµÖ»ÐèÒªÄãÔÚ³ÌÐòÖж¯Ì¬´«ÈëÖµ£¬ÀýÈçÔÚstruts»òservletÖж¯Ì¬´«ÈëÁ½¸ö²ÎÊý¾Í¿ÉÒÔ½øÐзÖÒ³¿ØÖÆ¡£
MSSQL SYBASEÏÂÃæÓÃtop À´·ÖÒ³
POSTGRESQL MYSQL¾ÍÖ±½ÓÓÃlimit¸ü¼òµ¥ÁË
ÔÚoracle ÏÂÃæÓÐ4ÖÖ·½·¨
oracle·ÖÒ³¼¼Êõ2007Äê08ÔÂ13ÈÕ ÐÇÆÚÒ» 23:08Á½ÖÖ·ÖÒ³¼¼Êõ£¬µÚ¶þÖÖЧÂʸ߶àÁË
1. select * from
    (select rownum rn,t.* from table t )
    where rn <50 and rn>=1
2. select * from
    (select rownum rn,t.* from table t rownum<50)
    where rn>=1
´øÅÅÐòÒªÇóµÄ·ÖÒ³£¬ÔÚ9iÒÔÉϵĻ·¾³ÍƼöʹÓ÷ÖÎöº¯Êý
select * from
(select row_number() over(order by esn) rn,esn,akey from as_esn_info )
where rn <50 and rn>=1
£¨ÒÔÉÏ·½·¨ÑéÖ¤¹ý£©
»òÕßÒÔÏÂ
£¨1£©minus²î·ÖÒ³ £ºselect * from table where rownum<=10 minus select * from table where rownum<=5
£¨2£©rownumαÁзÖÒ³ £ºselect * from (select rownum tid,t.* from table t  where rownum<=10) where tid>5
£¨3£©notinÏà·´·ÖÒ³£ºselect * from table where id not in(select id from table where rownum<=5) and rownum<=5


Ïà¹ØÎĵµ£º

oracle ¼Ç¼ºÏ²¢

ÔÚÒ»¸ö±íÖУ¬ÆäÖм¸¸ö×ֶεÄÖµÊÇÒ»ÑùµÄ£¬°´ÕÕÕ⼸¸ö×ֶνøÐзÖ×é²¢ºÏ²¢Êý¾Ý¡£
±íA     id     name         role
          1     ÕÅÈý    &nb ......

oracleÌåϵ½á¹¹¶þÖ®±í¿Õ¼ä¡¢·½°¸¡¢¶Î¡¢Çø¡¢¿é

     Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÊÇÊý¾Ý¿âÖÐ×îÖØÒªµÄÎļþ¡£ËüÃÇÊÇÊý¾Ý´æ´¢µÄµØ·½¡£Ã¿¸öÊý¾Ý¿âÖÁÉÙÓÐÒ»¸öÓëÖ®Ïà¹ØµÄÊý¾ÝÎļþ£¬Í¨³£Çé¿öϲ»Ö»Ò»¸ö£¬ÓкܶࡣÊý¾ÝÔÚÊý¾ÝÎļþÖÐÊÇÈçºÎ×éÖ¯µÄ£¿ÒªÁ˽âÕâЩÄÚÈÝÎÒÃÇÊ×ÏȱØÐëÀí½âʲôÊDZí¿Õ¼ä£¨tablespace£©¡¢¶Î£¨segment£©¡¢Çø£¨extent£©¡¢¿é£¨block£©£¬ÕâЩ¶¼ÊÇoracl ......

Oracle SpatialÖеÄOperator²Ù×÷×Ó Ïêϸ˵Ã÷

SDO_FILTER
¸ñʽ£º
    SDO_FILTER(geometry1, geometry2, params);
ÃèÊö£º
    ͨ¹ý¿Õ¼äË÷Òý£¬¸ù¾Ý¸ø¶¨µÄ¼¸ºÎÒªËØ¼ìË÷³ö¾ßÓпռäÏ໥¹ØÏµµÄ¿Õ¼ä¶ÔÏó¡£ÕâÀïµÄ¿Õ¼ä¹ØÏµÊÇÖ¸Á½¸ö¼¸ºÎ²»·ÖÀ룬¼´Non-disjoint¡£¡¾disjoint£º±íʾÁ½¸ö¼¸ºÎµÄ±ßºÍÄÚ²¿¶¼²»Ïཻ¡¿
    Õâ¸öSdo_Fi ......

Oracle SpatialÖÐSDO_GeometryÏêϸ˵Ã÷

 ÔÚArcGISÖÐͨ¹ýSDE´æ´¢¿Õ¼äÊý¾Ýµ½OracleÖÐÓжàÖÖ´æ´¢·½Ê½£¬·Ö±ðÓУº¶þ½øÖÆLong Raw ¡¢ESRIµÄST_GeometryÒÔ¼°»ùÓÚOracle SpatialµÄSDO_GeometryµÈµÈ¡£
      ¹ØÓÚÕ⼸ÖÖ·½Ê½µÄ¸÷×ÔµÄÓÅȱµã²»ÊÇÖ÷ÒªµÄ̽Ìֵķ½Ïò£¬ÕâЩÎÒÃÇ¿ÉÒÔͨ¹ýArcGISÖеÄArcGIS Server HelpµÃµ½Ïà¹ØµÄ°ïÖú¡£ÕâÀïÖ÷Ò ......

oracle jobС½á

Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ