The RENAME COLUMN statement allows you to rename an existing column in an existing table in any schema (except the schema SYS).
To rename a column, you must either be the database owner or the table owner.
Other types of table alterations are possible;
see
To rename the manager column in table employee to
supervisor, use the following syntax:
You can combine ALTER TABLE and RENAME COLUMN to modify a column's data
type. To change column c1 of table t to the
new data type NEWTYPE: