Re: Renaming Fields in an Oracle Table

kwelty_at_my-dejanews.com schrieb:
>
> Can someone give me some insight into the process that is required to > change
> a field name in an Oracle Table?

Hi

there is no direct possibility to change the name of the column. You have to rename the table and create a new one with the old name with create table xxx (col1,col2,col3) as select col1,oldcol,col3 from renamed_table;

Drop renamed_table.
create indexes and constraints like the ones on your old table.

Hope that helps
Kai Received on Thu Jan 28 1999 - 06:11:14 CST