Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Renaming a Column

RE: Renaming a Column

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 14 Feb 2001 06:09:07 -0800
Message-ID: <F001.002B3C4D.20010214052630@fatcity.com>

I didn't find it any of my docs for 8.1.7 either. Is renaming a column getting confused with dropping a column?

For renaming columns, one has to wait till 9i is a reality, I was told....

> -----Original Message-----
> From: Joseph S. Testa [SMTP:teci_at_oracle-dba.com]
> Sent: Wednesday, February 14, 2001 6:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Renaming a Column
>
> Ok i'll bite, i try to keep up with the new features and i'm looking at
> 8i(8.1.7) docs right now and i dont see it, would you like to elaborate?
>
> you can rename a table, rename a partition but NOT rename a column, this
> has been on the wish-list for many years just like drop column was.
>
> Feel free to flame me if i'm wrong(it does happen but rarely) :)
>
>
> joe
>
> "Johan Locke_at_i-Commerce Services" wrote:
> >
> > Wait wait wait...
> >
> > Yes you can rename a column in 8i, it just depends to what value your
> > compatibility parameter is set
> >
> > Regards
> > JL
> >
> > -----Original Message-----
> > Sent: Wednesday, February 14, 2001 8:05 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > 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
> > > 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).
> >
> > ____________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.co.in address at http://mail.yahoo.co.in
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?bipin=20sahani?=
> > INET: bipinsahani_at_yahoo.co.in
> >
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Johan Locke_at_i-Commerce Services
> > INET: Johan.Locke_at_za.didata.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).
>
> --
> Joe Testa http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.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).

-- 
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).
Received on Wed Feb 14 2001 - 08:09:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US