Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

SQLÓïÑÔ»ù´¡¿¼ºË(Ò»)(oracle)

 1.ÀûÓÃÏÂÃæµÄ½Å±¾´´½¨BOOK£¬READER ºÍ BORROW ±í£¬²¢Íê³ÉºóÃæµÄÁªÏµ¡£
CREATE TABLE BOOK(
    NO CHAR(8) PRIMARY KEY,
    TITLE VARCHAR2(50) NOT NULL,
    AUTHOR VARCHAR2(20) ,
    PUBLISH VARCHAR2(20),
    PUB_DA ......

oracle ±Ê¼Ç VIII Ö®ÊÂÎñºÍË÷Òý

 ÊÂÎñ¾ÍÊDZ»°ó¶¨ÔÚÒ»Æð×÷Ϊһ¸öÂß¼­¹¤×÷µ¥ÔªµÄSQLÓï¾ä·Ö×飬Èç¹ûÈκÎÒ»¸öÓï¾ä²Ù×÷ʧ°ÜÄÇôÕû¸ö²Ù×÷¾Í±»Ê§°Ü£¬ÒÔºó²Ù×÷¾Í»á»Ø¹öµ½²Ù×÷ǰ״̬£¬»òÕßÊÇÉÏÓиö½Úµã¡£ÎªÁËÈ·±£ÒªÃ´Ö´ÐУ¬ÒªÃ´²»Ö´ÐУ¬¾Í¿ÉÒÔʹÓÃÊÂÎñ¡£ÊÂÎñÓÐËĸöÌØÐÔ£¬·Ö±ðÊÇ£ºÔ­×ÓÐÔ£¬Ò»ÖÂÐÔ£¬¸ôÀëÐԺͳ־ÃÐÔ¡£
Ë÷Òý¾ÍÒ»ÖÖÌØÊâµÄ²éѯ±í£¬Êý¾Ý¿âµÄËÑË÷ÒýÇæ¿ ......

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µÄ¼¯ºÏÔËËã·û

±í1£ºtemp1
AA    BB    CC
1      1      1
1      1      2
1      1      3
±í2£ºtemp2
AA    BB  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ