Re: Renaming a Column

In 8.1.6 you can add a column with a new name and drop an old column. There is a number of reasons not to do this but you said you were desperate...

Regs
Karen Abgarian

Randall Woodman wrote:

> Sorry for the cross post but I'm desperate for an answer.
>
> Is there a way to rename a column in an existing table? For example,
> suppose I had a table named FOO.
>
> CREATE TABLE FOO (
> FOOWHO VARCHAR2 (12) NOT NULL,
> BARNONE VARCHAR2 (18) NOT NULL,
> FOOBAR VARCHAR2 (8) NOT NULL,
> )
>
> Now suppose I want to rename the column FOOBAR to FUBAR. I know I could do
> the following
> 1. Add a new column called FUBAR
> 2. update the column FUBAR with the data in FOOBAR
> 3. Drop the column FOOBAR
>
> However, I was thinking that there was a way to do this using a single
> ALTER statement. For example,
> alter table <table_name> rename column <column_name> new_column_name
> However, that doesn't work.
>
> I'm running Oracle 8.1.6
>
> Thanks for your help.
>
> -=} Randall {=-
Received on Mon Jul 16 2001 - 14:44:52 CDT