Yurttas/PL/DBL/oracle/F/01/SPJ/q10.sql
Jump to navigation
Jump to search
1REM
2REM q10.sql
3REM
4REM Set the shipment quantity to zero for all suppliers in
5REM 'Denver'.
6
7UPDATE Shipments
8SET quantity = 0
9WHERE sn IN (SELECT sn
10 FROM Suppliers
11 WHERE city = 'Denver');