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

From ZCubes Wiki
Revision as of 23:13, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM q08.sql REM REM Change the color of part 'P02' to 'Yellow', REM increase its weight by 5, and REM set its cit...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search 
 1REM
 2REM q08.sql
 3REM
 4REM Change the color of part 'P02' to 'Yellow',
 5REM increase its weight by 5, and
 6REM set its city to unknown('NULL').
 7REM
 8
 9UPDATE Parts
10SET color='Yellow',
11    weight=weight+5,
12    city='NULL'
13WHERE pn = 'P02';
Retrieved from "http://wiki.zcubes.com/index.php?title=Yurttas/PL/DBL/oracle/F/01/SPJ/q08.sql&oldid=79796"