Changing Column Names in Oracle

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: