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