Re: Rename columns

From: Andrei Kirilenkov <akirilenkov_at_sovintel.net>
Date: Mon, 6 Aug 2001 10:11:33 +0400
Message-ID: <9klcmk$11ff$1@josh.sovintel.ru>

hi,
1. create table t1 with the needed column names 2. insert all the data from t
begin
for z in (select * from t) loop

    insert into t1 (...) values(z.c1, ...) ; end loop;
end;

3. drop t
4. create t as select * from t1;
5. drop t1

that's all
regards

"Jordan" <mj_at_nba.com> wrote in message
news:cre$83s1_at_imsp212.netvigator.com...
> Hi, I want to know how to rename the column name in a table, thanks..
>
>
>
Received on Mon Aug 06 2001 - 01:11:33 CDT