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

From ZCubes Wiki
Jump to navigation Jump to search
1REM
2REM q09.sql
3REM
4REM Double the status of all suppliers in 'Houston'.
5REM
6
7UPDATE Suppliers
8SET status = status*2
9WHERE city = 'Houston';