函数INITCAP()是将每个单词的第一个字母大写,其它字母变为小写返回.

　　单词由空格,控制字符,标点符号等非字母符号限制.

select initcap('hello world') from dual;

　　结果

　　INITCAP('HELLO WORLD')

　　-----------

　　Hello World

SELECT TRUNC(15.79,1) "Truncate" FROM DUAL;

  Truncate
----------
      15.7

SELECT TRUNC(15.79,-1) "Truncate" FROM DUAL;

  Truncate
----------
        10

The following example rounds a number to one decimal point:

SELECT ROUND(15.193,1) "Round" FROM DUAL;

     Round
----------
      15.2

SELECT ROUND(15.193,-1) "Round" FROM DUAL;

     Round
----------
        20

functions