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: PL. Rukmani <mani_at_TC4HQ.CMC.STPH.NET>
Date: Sun, 31 Dec 1995 18:19:06 -0500
Message-Id: <9512311303.AA11908@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.
>

Hello Seniors and Experts,

   Just being a bit curious... Aren't all x$ tables undocumented ? Is there a way to get the list of x$ tables and their descriptions ? All I know is x$kppi which stores the parameter name and value.

   Thanks,
   Rukmani. Received on Sun Dec 31 1995 - 08:03:09 CST

Original text of this message

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