Rename Column in Oracle SQL / PLSQL
To rename a column in an existing table use the following:ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn;
A developer's guide to Record Linkage, List Hygiene, Database Marketing and Customer Data Integration. Tips and Tricks from Java, SQL, Awk and other programming languages that are useful in achieving an accurate customer database.
To rename a column in an existing table use the following:ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn;