Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: Rename Column
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
![]() |
![]() |