Tuesday, September 26, 2006

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;