
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