Skip to main content

Nesting Functions

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

i.e.


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

nesting-function