Re: Renaming a field

DerWoud wrote:

> 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;
>

And add PK, FK in, FK out, comments, indexes, etc. There is alot more to it than that, I see it as I am writing the rename column package.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
(home)
Vice-President Ohio Oracle Users Group, try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second, third,
etc, instance, without using oracle's installer, database scripts.
ICQ UIN:  2832230(&oracle, home).