Re: Renaming a field

I hope this might help ya, if not then consider this more useless internet traffic:

Rename table1 to a_temp_table;

create table1 as(
select field1 field1_new_name, field2, field3 from a_temp_table);

drop a_temp_table;

Yee! No tools needed except SQL Plus.
DerWoud
derwoud_at_bellsouth.net

On 1 Nov 1997 00:38:29 GMT, "James Wj Snyder" <snyderj_at_wellsfargo.com> wrote:

>Hello Peoples,
>
>anyone know of a way to rename an oracle field. With ANY tool?
>--
>Peace,
>James Wj Snyder
>Shattered Rose Studio
>** ClubWin Member **
>www.shatteredrose.com
Received on Tue Nov 04 1997 - 00:00:00 CET