oracle教学课件尚硅谷宋红康03单行函数.ppt

Nesting Functions (continued) The slide example displays the head of the company, who has no manager. The evaluation of the SQL statement involves two steps: 1. Evaluate the inner function to convert a number value to a character string. Result1 = TO_CHAR(manager_id) 2. Evaluate the outer function to replace the null value with a text string. NVL(Result1, No Manager) The entire expression becomes the column heading because no column alias was given. Example Display the date of the next Friday that is six months from the hire date. The resulting date should appear as Friday, August 13th, 1999