RE: Renaming a Column

Boy, am I tired
of people suggesting this kind of thing.  What's the point, when there are SUPPORTED and SAFE ways of doing what you want?  Paul Baumgartel <FONT face=Tahoma
size=2>InstiPro, Inc. <FONT face=Tahoma size=2>paul.baumgartel_at_instipro.com 212 813-0829 x103 (office) 917
549-4717         (mobile)

  <FONT face=Tahoma
  size=2>-----Original Message-----From: neena   [mailto:neena_at_bom7.vsnl.net.in]Sent: Wednesday, February 14, 2001   12:23 PMTo: Multiple recipients of list ORACLE-LSubject:   Re: Renaming a ColumnHi,
        The suggestion till yet provided are the   correct ones and safest. But try this in your test database, get you   table id from sys.obj$ table. Then get the columns details from sys.col$ table   by giving the table id in where clause. Update the row which corresponds to   the column which you want  to  modify.  

• neena ??? wrote: from Oracle 8i you can drop columns with -- alter table table_name drop column column_name; and then your can add columns with the name to which you want to rename alter table table_name add(column_name type); -----Original Message----- From: root_at_fatcity.com [<A href="mailto:root_at_fatcity.com">mailto:root_at_fatcity.com]On Behalf Of bipin sahani Sent: Wednesday, February 14, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Subject: 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 > <A
  href="http://www.hotmail.com">http://www.hotmail.com. > >
  • > Please see the official ORACLE-L FAQ: > <A href="http://www.orafaq.com">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 <A href="http://mail.yahoo.co.in">http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com">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).>W&#353;±ėzŲ^”÷ār&„9,BÅ
    m¶&#376;’Ć(­§Ś©Ź&ėa¢² 9c±ż}v·&#353;&#8250;Ž“V­ +r5ėp¢¹z»āqė<ēĪwó9ŌPó&#376;9ßĪtēT&#353;oe8&#382;'&#8364;&#353;-'č®x&#353;>ęå&#8240;Ā'µźēzÖoeqė,üĘ¢-)ą.+-±:Ć**.®Ē„}śč&#353;Ųb²f¢-)ą-+-±éŻjqj)fzĖ