Sticky-note

The ALTER TABLE statement specifies EMPLOYEES as the table to alter. The MODIFY clause permanently modifies the format of the Salary column. The DROP clause permanently drops the Phone column.

   alter table employees
      modify salary num format=dollar8.
      drop phone;