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

Oracle ¿ª·¢³£¼ûÎÊÌâ

 1£®Êýѧº¯Êý
¢Ù¾ø¶ÔÖµ 
l  S£ºselect abs(-1) value
l  O£ºselect abs(-1) value from dual
¢ÚÈ¡Õû(´ó) 
l  S£ºselect ceiling(-001) value 
l  O£ºselect ceil(-001)   value from dual
¢ÛÈ¡Õû£¨Ð¡£© 
l  S£ºselect floor(-001) value   
l  O£ºselect floor(-001) value from dual
¢ÜÈ¡Õû£¨½ØÈ¡£©
l  S£ºselect cast(-002 as int)   value  
l  O£ºselect trunc(-002) value from dual 
¢ÝËÄÉáÎåÈë
l  S£ºselect round(23456,4) value     23460
l  O£ºselect round(23456,4) value from dual 2346
¢ÞeΪµ×µÄÃÝ 
l  S£ºselect Exp(1) value          l  O£ºselect Exp(1) value from dual  
¢ßÈ¡eΪµ×µÄ¶ÔÊý
l  S£ºselect log(7182818284590451) value      
l  O£ºselect ln(7182818284590451) value from dual;  
¢àÈ¡10Ϊµ×¶ÔÊý
l  S£ºselect log10(10) value         
l  O£ºselect log(10,10) value from dual;   
¢áȡƽ·½
l  S£ºselect SQUARE(4) value   
l  O£ºselect power(4,2) value from dual  
¢âȡƽ·½¸ù l  S£ºselect SQRT(4) value   
l  O£ºselect SQRT(4) value from dual  
ÇóÈÎÒâÊýΪµ×µÄÃÝ
l  S£ºselect power(3,4) value      
l  O£ºselect power(3,4) value from dual  
È¡Ëæ»úÊý
l  S£ºselect rand() value  
l  O£ºselect sys.dbms_random.value(0,1) value from dual;
È¡·ûºÅ
l  S£ºselect sign(-8) value    -1
l  O£ºselect sign(-8) value from dual  -1
2£®ÊýÖµ±È½Ï
¢ÙÇ󼯺Ï×î´óÖµ l  S£ºselect max(value) value from 
    (select 1 value union
    select -2 value union
    select 4 value union
  &n


Ïà¹ØÎĵµ£º

ORACLE³£ÓÃFAQ

 µÚÒ»²¿·Ö¡¢SQL&PL/SQL
[Q]ÔõôÑù²éÑ¯ÌØÊâ×Ö·û£¬ÈçͨÅä·û%Óë_
[A]select * from table where name like 'A_%' escape ''
[Q]ÈçºÎ²åÈëµ¥ÒýºÅµ½Êý¾Ý¿â±íÖÐ
[A]¿ÉÒÔÓÃASCIIÂë´¦Àí£¬ÆäËüÌØÊâ×Ö·ûÈç&Ò²Ò»Ñù£¬Èç
insert into t values('i'||chr(39)||'m'); -- chr(39)´ú±í×Ö·û'
»òÕßÓÃÁ½¸öµ¥ÒýºÅ±íʾһ¸ö
or ......

OracleÖÐDecode()º¯ÊýʹÓü¼ÇÉ


¡¡¡¡decode()º¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£
      DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐÊ²Ã´Ó ......

oracle ÊÓÆµ±Ê¼Ç2(CreateNewUser)

 1.±¸·Ýscott
£¨1£©ÔÚCÅ̵ĸùĿ¼Ï´´½¨Ò»¸öÎļþ¼Ðtemp
£¨2£©ÔÚcmdÔÚ½øÈëÎļþ¼Ð£¬del *.* £¬É¾³ýËùÓÐÎļþ¡£
£¨3£©ÊäÈëexp
£¨4£©ÊäÈëÓû§ÃûºÍÃÜÂë:scott/tiger
£¨5£©¾Í»áÏÔʾ“ÊäÈëÊý×éÌáÈ¡»º³åÇø´óС”£¬ÔÚÕâÒ»²½Ö±½Ó»Ø³µ¾ÍÐÐÁË
£¨6£©ÏÔʾ“µ¼³öÎļþ£ºDXPDAT.DMP>”£¬ÕâÒ»²½Ò²Êǻسµ
£¨ ......

110¸öoracle³£Óú¯Êý×ܽá

 1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH ......

ORACLE GROUPINGº¯ÊýµÄʹÓÃ

GROUPINGº¯Êý¿ÉÒÔ½ÓÊÜÒ»ÁУ¬·µ»Ø0»òÕß1¡£Èç¹ûÁÐֵΪ¿Õ£¬ÄÇôGROUPING()·µ»Ø1£»Èç¹ûÁÐÖµ·Ç¿Õ£¬ÄÇô·µ»Ø0¡£GROUPINGÖ»ÄÜÔÚʹÓÃROLLUP»òCUBEµÄ²éѯÖÐʹÓᣵ±ÐèÒªÔÚ·µ»Ø¿ÕÖµµÄµØ·½ÏÔʾij¸öֵʱ£¬GROUPING()¾Í·Ç³£ÓÐÓá£
¹ØÓÚROLLUPºÍCUBEº¯ÊýµÄʹÓã¬Çë²Î¼ûÎÒµÄÁíһƪÎÄÕ¡£
http://blog.csdn.net/wh62592855/archive/2009/1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ