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

 

转载于:https://www.cnblogs.com/arcer/archive/2013/04/12/3016975.html