A CTE can be thought of as a named temporary table within a SQL statement that is retained for the duration ... Figure 1 shows a hierarchic organization chart. The MGR_ID for the top-most node is set ...