Re: How to rename a column name?

rename table, create a view with new column name, old table name

On Mon, 13 Sep 1999 11:19:49 GMT, wy3141_at_my-deja.com wrote:

> I want to change the column name,and I don't want to drop it and
>recreate it. Because it has some dependencies(role right,constraints)
>on it.
> Can Oracle support change the column name directly?
> Any suggestion are helpful.
> Thanks in advance.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email