PL/SQL hand on 5

                                   PL/SQL hand on 5
____________________________________________________________________________


SET NULL "NULL";
SET FEEDBACK OFF;
SET ECHO OFF;
SET HEADING OFF;
SET WRAP OFF;
SET LINESIZE 10000;
SET TAB OFF;
SET PAGES 0;
SET DEFINE OFF;

alter table Employees add Grade varchar(255);
update Employees
set Grade='Senior manager' where Salary>=30000;
update Employees
set Grade='Middle manager' where Salary<30000 and Salary>=25000;
update Employees
set Grade='Junior manager' where Salary<25000 and Salary>=20000;
update Employees
set  Grade='Team member' where Salary<20000;
select Name,Grade from Employees;
exit;