Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: Rename Column

Re: Newbie: Rename Column

From: Jos <jochen-nospam-_at_pophost.eunet.be>
Date: Thu, 10 Jun 1999 11:39:18 +0200
Message-ID: <375F87C6.914B93FB@pophost.eunet.be>


You cannot rename a column.
Workaround: create a new table with the same columns except the ones you wanted to rename.
Something like : create table y(f1, f2, f4) as (select f1, f2, f3 from x);

HTH Jochen.

"Robert S. Moore" wrote:
>
> Is there an easy way to do this?
>
> Thanks,
>
> Bob
> rsmoore_at_solidearth.com
Received on Thu Jun 10 1999 - 04:39:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US