Re: How to rename columns'name in a table?

Hi,
you cann't do that. There is no command for renaming a column. You have to recreate the table with the new name.

There are two ways: 1. create table <new_table> as select <new_column_name> ,.... from old_table.

                                2. create a view on the base_table and

> Hi,
>
> Somebody, please, tells me which (SQL) command I can use to rename
> columns'name in a table.
> I know that I can use 'alter table <old_name> rename to <new_name>'
> to rename a table' s name. I have no idea for a column's name.
>
> Thanks in advance,
> -sirirut-

--
_____________________________________________________________________________

Karl-Heinz Schubert   Tel.  : +49 89  75981-245
Senior Consultant   Fax   : +49 89  75981-150
Notkestraße 15
22607 Hamburg          e-mail: kschuber_at_de.oracle.com
_____________________________________________________________________________

Opinions are mine and do not necessarily reflect those of Oracle
Corporation