Yurttas/PL/DBL/oracle/F/01/Movie/q08.sql
Jump to navigation
Jump to search
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);