Update: It's Time For A Raise!!! (II)

Syntax

UPDATE <table_name>
SET { <column_name> = <expression> [, <column_name> = <expression>] ...}
WHERE <condition>;

Update CLERK Salaries

SQL> update emp set sal = sal + sal*.10 where job = 'CLERK';

4 rows updated.

The Mail Will Get Delivered!

SQL>  select ename,job,sal from emp where job= 'CLERK';


ENAME	   JOB		    SAL
---------- --------- ----------
SMITH	   CLERK	    880
ADAMS	   CLERK	   1210
JAMES	   CLERK	   1045
MILLER	   CLERK	   1430

Or Will It? ROLLBACK

SQL> rollback;

Rollback complete.

SQL>  select ename,job,sal from emp where job= 'CLERK';


ENAME	   JOB		    SAL
---------- --------- ----------
SMITH	   CLERK	    800
ADAMS	   CLERK	   1100
JAMES	   CLERK	    950
MILLER	   CLERK	   1300