Oracle does not have a mechanism by which you directly change column names. But this workaround is quick and efficient.
Consider TableA:
COLUMN_1 NUMBERCOLUMN_2 VARCHAR2(500)COLUMN_3 DATE
You want to change it to TableB:
NEW_COLUMN_1 NUMBERNEW_COLUMN_2 VARCHAR2(500)NEW_COLUMN_3 DATE
then use the following SQL.
CREATE TABLE TableB (NEW_COLUMN_1, NEW_COLUMN_2, NEW_COLUMN_3) AS SELECT (COLUMN_1, COLUMN_2, COLUMN3) FROM TableA;
TableB will have the new columns as expected.