Renaming a Column

[Quoted] [Quoted] Sorry for the cross post but I'm desperate for an answer.

[Quoted] 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 - 17:08:51 CEST