Re: Rename a column

From: <Uge_at_VaxMan.prestel.co.uk>
Date: Tue, 05 Jan 1999 15:14:27 GMT
Message-ID: <369212d0.14701500_at_news.prestel.co.uk>

How about this:

1. create table FRED  (column elements...)
2. insert into FRED select col1, col2... from OLD
3. drop table OLD
4. rename FRED to OLD

Eugene (Oracle Certified dba seeking employment).

---

Bob Stearns <rstearns_at_bellsouth.net> wrote:

> I am new to the Oracle environment, but have had lots of various
> database experience. I am unable to find a way to rename a column after
> I have loaded a database. In particular, I need to regularize the column
> names of a multi-table database so that the same name is used for the
> same data content every where it occurs.
Received on Tue Jan 05 1999 - 16:14:27 CET