Re: Rename a column in 8i - Really?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 12 Jun 1999 16:08:32 GMT
Message-ID: <376d85d7.5954642@newshost.us.oracle.com>

A copy of this was sent to coakleyj_at_hotmail.com (if that email address didn't require changing) On Sat, 12 Jun 1999 13:28:17 GMT, you wrote:

>Hi everyone.
>
>I have read in this newsgroup that it is possible to
>rename a column in Oracle 8i. Is this really true?
>
>The only thing I've been able to find in the manuals allows
>me to set a column unusable or to drop a column:
>
>alter table <table> set unusable column <col1>;
>&
>
>alter table <table> drop column <col1>;
>
>
>How (if at all) can I do the rename automatically in 8i.
>

you cannot rename a column. you could create a new column of the same type with a new name, update it to the other value and drop the old column

of course using a view would be infinitely more efficient.

>
>
>Regards
>Coakleyj
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Jun 12 1999 - 11:08:32 CDT