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

From ZCubes Wiki
Revision as of 23:01, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM q08.sql REM REM Modify the relation MovieExec(name, address, REM cn, networth) by prepending the title Pres...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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);
Retrieved from "http://wiki.zcubes.com/index.php?title=Yurttas/PL/DBL/oracle/F/01/Movie/q08.sql&oldid=79364"