--- set 

The `set' clause lets you update specific fields in existing records.
   You can use constants, fields, expressions or query statements
   to perform the update.  This clause is always used with the
   `update' clause.

EXAMPLE:

   Change Owens' salary to $1000.

	  sql> update emp
	  sql> set salary = 1000
	  sql> where name = 'Owens*'/

   Make Brown's salary equal to the maximum salary for all employees.

          sql> update emp
          sql> set salary = select max(salary) from emp;
          sql> where name = 'Brown*'/
