From Locke@i-Commerce Wed, 14 Feb 2001 05:34:11 -0800 From: "Johan Locke@i-Commerce Services" Date: Wed, 14 Feb 2001 05:34:11 -0800 Subject: RE: Renaming a Column Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi All I think I did send one out earlier. Don't bite. You can't rename a column. The combatibility parameter issue I was thinking of has to do with when you want to drop a column in 8i. That I know, has to be greater or equal to 8.1.0 when you want to drop a column Sorry again Regards JL -----Original Message----- Sent: Wednesday, February 14, 2001 2:10 PM To: Multiple recipients of list ORACLE-L 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@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 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@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@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@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@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@i-Commerce Services > INET: Johan.Locke@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@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@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@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@i-Commerce Services INET: Johan.Locke@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@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).