Rename a column in 8i

From: <coakleyj_at_hotmail.com>
Date: Sat, 12 Jun 1999 13:28:17 GMT
Message-ID: <7jtn9d$9ub$1@nnrp1.deja.com>

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.

Regards
Coakleyj

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 12 1999 - 08:28:17 CDT

Rename a column in 8i - Really?