Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rename columns
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
"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