Home > SQL, Technical > Rename a column name in Oracle

Rename a column name in Oracle

July 27, 2012

Syntax: ALTER TABLE TABLE_NAME RENAME COLUMN COLUMN_NAME to NEW_COLUMN_NAME;

Example: ALTER TABLE ORDERS RENAME ORDER_CODE to O_CODE;

Advertisements
Categories: SQL, Technical
%d bloggers like this: