Yurttas/PL/DBL/oracle/F/01/SPJ/q08.sql
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';