Yurttas/PL/DBL/oracle/F/01/Movie/q08.sql

 1REM
 2REM q08.sql 
 3REM
 4REM Modify the relation MovieExec(name, address, 
 5REM cn, networth) by prepending the title Pres.  
 6REM in front of every movie executive who is 
 7REM the president of a studio.
 8REM
 9
10UPDATE MovieExec
11SET name = 'Pres. ' || name
12WHERE cn IN (SELECT presCN
13             FROM Studio);