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: Paul Baumgartel <PaulB_at_instipro.com>
Date: Wed, 14 Feb 2001 10:09:28 -0800
Message-ID: <F001.002B43A4.20010214094119@fatcity.com>

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.

Received on Wed Feb 14 2001 - 12:09:28 CST

Original text of this message

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