Yurttas/PL/DBL/postgres/F/01/Company-B/q14.sql

 1/*
 2REM
 3REM q14.sql
 4REM
 5REM Give all employees of 'First Bank Corporation' a 10 percent raise.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companyb";
11
12UPDATE Works
13SET salary = salary * 1.1
14WHERE companyname = 'First Bank Corporation';