Re: rename a column

From: <rannerde_at_my-deja.com>
Date: Thu, 08 Feb 2001 17:23:13 GMT
Message-ID: <95uklk$1cs$1@nnrp1.deja.com>

Thank you very much, Robert!
I am going to try it...

Gerfried

In article <95uj17$vkm$1_at_nnrp1.deja.com>, robertboyle_at_my-deja.com wrote:
> In article <95ui8l$uue$1_at_nnrp1.deja.com>,
> rannerde_at_my-deja.com wrote:
> > Dear NG!
> > How do I rename an existing column of a table with Oracle SQL?
> >
> > Thank you,
> > Gerfried Ranner
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
> You can't rename a column. Try creating a temp table with your data
> and then dropping and recreating your table:
>
> CREATE TABLE temptable AS
> SELECT * FROM existingtable;
>
> DROP TABLE exisitingtable;
>
> CREATE TABLE (new definitions and column names);
>
> INSERT INTO existingtable
> SELECT * FROM temptable;
>
> DROP TABLE temptable;
>
> COMMIT;
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 08 2001 - 11:23:13 CST