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

oracleµÄËæ»úÅÅÐò

ÏîÄ¿ÀïÒ»¸ö¹¦ÄÜÒªÓõ½Ëæ»úÅÅÐò£¬µ«ÊǺóÀ´ÓÖÒòΪÊý¾ÝÁ¿´óµÄÔ­Òò£¬Òª·Öҳȥ²éѯÊý¾Ý£¬½á¹ûµ¼Ö²éѯ³öÀ´µÄÊý¾Ý³öÏÖÖØ¸´¡£
Ô­sqlÈçÏÂselect * from ( select row_.*, rownum rownum_ from
(select * from tble order by dbms_random.random) row_ where rownum <= 12) where rownum_ > 10;
 
ºóÀ´½â¾ö°ì·¨£¬²åÈëÒ»ÕÅÁÙʱ±í¼ÇÂ¼Ëæ»ú³öÀ´µÄÊý¾Ý£¬È»ºó°´ÁÙʱ±í·Öҳȥ²é£¬Ïë²»µ½ºÃ°ì·¨£¬Ö»Äܵ±ÈÎÎñÀ´Íê³ÉÁË¡£
¹ýÂ˵ôorder by µÄÅÅÐòÕýÔò
sql = sql.replaceAll("order by [^\\)]+", "");



Ïà¹ØÎĵµ£º

Oracle Spatail ÌØÀí´æ´¢½á¹¹

MDSYS.CS_SRS ----- ¸Ã±í¶¨ÒåÁË×ø±êϵµÄÃû×Ö¼°ÆäÔÚOracle SpatialÖеÄIDÖµµÈ£¬ÕâÐ©×ø±êϵ¶¼ÊÇÓÉOpen-GIS¹«²¼µÄ¡£Ä¿Ç°¶¨ÒåµÄ×ø±êϵÒѾ­´ïµ½1018¸ö¡£
MDSYS.SDO_ANGLE_UNITS ----- ¸Ã±í¶¨ÒåÁ˽Ƕȵ¥Î»£¬·Ö±ðÊÇDegree,Gon,Grad,Minute,Radian,Second
MDSYS.SDO_DIST_UNITS ----- ¸Ã±í¶¨ÒåÁ˾àÀëµÄµ¥Î»¡£±ÈÈçkm,m£¬¹²ÓÐ27ÖÖ¾à ......

Oracle ÏÔʽÓαê

--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
       --ÉùÃ÷Óαê
       cursor mycur is select * from employees where employee_id<120;
       --¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓ ......

Oracle»ù±¾¸ÅÄî/ÊõÓï

Oracle»ù±¾¸ÅÄî/ÊõÓï
􀂃 Êý¾Ý¿â£¨Database£©
ÊÇ´ÅÅÌÉÏ´æ´¢µÄÊý¾ÝµÄ¼¯ºÏ£¨°üÀ¨ÅäÖÃÎļþ¡¢Êý¾ÝÎļþ¡¢ÈÕÖ¾ÎļþºÍ¿ØÖÆÎÄ
¼þµÈ£©
􀂃 Êý¾Ý¿âʵÀý£¨Database Instance£©
ÔËÐÐÔÚÊý¾Ý¿âÎļþÉϵÄÒ»×éOracleºǫ́½ø³Ì/Ïß³ÌÒÔ¼°Ò»¸ö¹²ÏíÄÚ´æÇø¡£Êý¾Ý
¿â¿ÉÒÔÓÉʵÀý×°ÔØºÍ´ò¿ª¡£
􀂃
􀂃 Êý¾Ý¿â·þÎ ......

OracleÖÐSQLÓï¾ä½âÎöµÄ²½Öè

ÎÒÃǶ¼ÖªµÀÔÚOracleÖÐÿÌõSQLÓï¾äÔÚÖ´ÐÐ֮ǰ¶¼ÐèÒª¾­¹ý½âÎö£¬ÕâÀïÃæÓÖ·ÖΪÈí½âÎöºÍÓ²½âÎö¡£ÄÇôÕâÁ½ÖÖ½âÎöÓкβ»Í¬Ö®´¦ÄØ£¿ËüÃÇÓÖ·Ö±ðÊÇÈçºÎ½øÐнâÎöÄØ£¿OracleÄÚ²¿½âÎöµÄ²½ÖèÓÖÊÇÈçºÎ½øÐеÄÄØ£¿ÏÂÃæÎÒÃǾÍÕâЩ»°Ìâ½øÐй²Í¬Ì½ÌÖ¡£ ÔÚOracleÖдæÔÚÁ½ÖÖÀàÐ͵ÄSQLÓï¾ä£¬Ò»ÀàΪDDLÓï¾ä£¬ËûÃÇÊÇ´ÓÀ´²»»á¹²ÏíʹÓõģ¬Ò²¾ÍÊÇÿ´ÎÖ´ ......

Oracle¿Í»§¶ËNLS_LANGÉèÖÃ


1. NLS_LANG
²ÎÊý×é³É
NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients
Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄϰ¹ß
CHARACTERSET:
-¿Ø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ