From ramakrishna.gv@db.com Wed, 14 Feb 2001 00:42:20 -0800 From: ramakrishna.gv@db.com Date: Wed, 14 Feb 2001 00:42:20 -0800 Subject: RE: Renaming a Column Message-ID: MIME-Version: 1.0 Content-Type: text/plain if it is oracle 815 onwards insert new column in the table. insert data into new column from the old column in the table alter table drop column Thanks & Regards ---------------------------- Ram ---------------------------------------- Message History ---------------------------------------- Please respond to ORACLE-L@fatcity.com To: ORACLE-L@fatcity.com cc: Hessu, One of the ways: create table newtable (newcolumn1,newcolumn2,newcolumn3,...) as select * from oldtable ; rename newtable to oldtable; HTH Suhen 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: Suhen.Pather@strandbags.com.au 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: INET: ramakrishna.gv@db.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).