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

From ZCubes Wiki
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';