Re: Can I rename Columns?

From: Scott Duffy <bb036_at_torfree.net>
Date: 1995/09/24
Message-ID: <DFEAsI.7n1.0.sheppard_at_torfree.net>#1/1


Bart lonchar (belonch_at_bcbso.com) wrote: : Is it possible in Oracle 7 to rename a column (on the catalog) once a table is defined? If so, how - and if not - why not?

No. If you have this luxury, you can rename the table to another name, redefine the entire table, and then INSERT INTO X (SELECT * FROM Y);

-- 
----------------------------------------------------------------------

"" Scott Duffy ""
"" bb036_at_torfree.ca ""
"" "The views I express are not necessarily the same as my own." ""
Received on Sun Sep 24 1995 - 00:00:00 CEST

Original text of this message