Chapter 04-Using Conversion Functions and Conditional Expressions-Nesting Functions

Nesting Functions

  • Single-row functions can be nested to any level.
  • Nested functions are evaluated from the deepese level to the least deep level.

 

View Code 
SQL> SELECT last_name,UPPER(CONCAT(SUBSTR(LAST_NAME,1,8),'_US')) FROM employees WHERE department_id = 60;

LAST_NAME                 UPPER(CONCAT(SUBSTR(LAST_NAME,1,8),
------------------------- -----------------------------------
Hunold                    HUNOLD_US
Ernst                     ERNST_US
Austin                    AUSTIN_US
Pataballa                 PATABALL_US
Lorentz                   LORENTZ_US

 

posted @ 2013-04-12 16:51  ArcerZhang  阅读(101)  评论(0)  编辑  收藏  举报