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: Bambi Bellows <Bambi_Bellows_at_PO.CHI02_at_SMTPLINK.INFORES.COM>
Date: Fri, 29 Dec 1995 14:02:19 EST
Message-Id: <9512301925.AA27434@alice.jcc.com>

     Joe --

     If you can get the name of that x$ table out of your sogged mind,
     next eggnog is on me!  The only way that I know of to rename a
     column is to create another table with the column name you want
     as select * from x, then drop x, and rename your new table to x,
     and you're done.  Makes sense that you can screw around with the
     internals; the column name has to be kept somewhere; but, it reeks
     of danger to me... and I'd like to test it out.

     Best for 96!
     Bambi.

Received on Sat Dec 30 1995 - 14:25:34 CST

Original text of this message

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