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