Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Renaming a column
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
![]() |
![]() |