Re: rename a column?

Tom La Porte wrote:
>
> Is there any way to rename a column, other than recreating the table?
>
> The ALTER TABLE command allows you to change constraints and
> data types on a column, but doesn't seem to allow a name change.
>
> It's not a crucial issue, but I couldn't find anything in my brief
> search of the Oracle docs. Just wondering if I missed something obvious.
>
> Any suggestions are appreciated.
>

You can create a view on the table which substitutes the correct name for the incorrect one. Of course, then the view name will need be different from the actual table name if it's in the same schema!

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||