Re: How do you rename a column in a table?

> How do you rename a column in a table?

depending on the Oracle version you have:

1. Create a temporary table with the name structure and renamed field; move all data from original to temp table; delete source table; recreate original table with correct field name; move data back from temp to new table; delete temp table.
2. ALTER TABLE with rename field syntax (latest version of Oracle only). Read the docs for more info.