RE: Renaming a Column

I have seen such tricks before.. And wonder how many brave DBAs really do this (in Production and Mission Critical Databases). I, for sure, will stay away from messing with SYS.anything if it is not recommended by Oracle.
I am not Chuck Yeager !!

• Kirti

> -----Original Message-----
> From: Trassens, Christian [SMTP:CTrassens_at_uni2.es]
> Sent: Wednesday, February 14, 2001 3:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Renaming a Column
>
> Well, it isn't recommend it but you can update the field name of sys.col$
> table.
>
> Regards.
>
> > -----Mensaje original-----
> > De: bipin sahani [SMTP:bipinsahani_at_yahoo.co.in]
> > Enviado el: miércoles 14 de febrero de 2001 7:05
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Re: Renaming a Column
> >
> > In Oracle
> > It's not possible to rename a column.You can instead
> > use alias for that column name in your queries.
> > Or you have to create a new table from existing one
> > Drop existing table.And recreate a table by
> > selecting from new table.
> >
> > Regards
> > Bipin
> > --- Heikki Jantunen <hjantunen_at_hotmail.com> wrote: >
> > Hi all,
> > >
> > > I need to rename some columns on my table. Any idea
> > > how to do that...
> > >
> > > Thanks in advance,
> > >
> > > Hessu
> > >
> >
> _________________________________________________________________________
> > > Get Your Private, Free E-mail from MSN Hotmail at
> > > http://www.hotmail.com.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Heikki Jantunen
> > > INET: hjantunen_at_hotmail.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).