decode()函数:
decode(条件,值1,翻译值1,翻译值2)
IF(条件==值1)
RETURN 翻译值1
ELSE
RETURN 翻译值2
TABLE: category
tag url
2 =========
select decode(t.tag,'1',url,'xxx') as title
form category t
Title
xxx
trunc()函数:
截取日期或数字(不是四舍五入)
SQL> select trunc(sysdate) from dual;
TRUNC(SYSD
----------
07-1月 -03
SQL> select trunc(sysdate, 'mm ') from dual;
TRUNC(SYSD
----------
01-1月 -03
SQL> select trunc(sysdate, 'yy ') from dual;
TRUNC(SYSD
----------
01-1月 -03
SQL> select trunc(234.5565) from dual;
TRUNC(234.5565)
---------------
234
SQL> select trunc(sysdate, 'D ') from dual;
TRUNC(SYSD
----------
05-1月 -03
select trunc(-123.456),trunc(-123.456),trunc(-123.456,-1) from dual;
TRUNC(-123.456) TRUNC(-123.456) TRUNC(-123.456,-1)
--------------- --------------- ------------------
-123 -123 -120