Re: Changing the name of a column

Dave Mausner Braun Technology Group d-mausner_at_nwu.edu advises:

You cannot do it directly or in one step. you can:

1. use sqlplus COPY to create a new table with new column names, then drop the old table and rename the new one; or
2. create a view with new column names, and a synonym of the view which has the name of the original table and which yields the view.