
/* Code Fragment 6.22 Bob was promoted to Director of the Computer Center. */

UPDATE INCUMBENTS 
SET PCN = (SELECT PCN
           FROM POSITIONS,JOB_TITLES
           WHERE POSITIONS.JOB_TITLE_CODE1 = JOB_TITLE_CODE
           AND JOB_TITLE = "Director, Computer Center")
WHERE SSN = '111-22-3333'
