Rename column of a view

#1

Oracle 9.0.
Is it possible to rename the column of a view? Or is the only way of
doing it is to drop and recreate the view with the new column name?
Thanks,
Sashi

#2

On Oct 17, 10:35 am, Sashi <small... (AT) gmail (DOT) com> wrote:

Quote:

Oracle 9.0.
Is it possible to rename the column of a view? Or is the only way of
doing it is to drop and recreate the view with the new column name?
Thanks,
Sashi

Drop and recreate the view.

David Fitzjarrell

#3

On Oct 17, 10:35 am, Sashi <small... (AT) gmail (DOT) com> wrote:

Quote:

Oracle 9.0.
Is it possible to rename the column of a view? Or is the only way of
doing it is to drop and recreate the view with the new column name?
Thanks,
Sashi

Drop and recreate the view.

David Fitzjarrell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Rename column of a view

comp.databases.oracle.misc comp.databases.oracle.misc

Rename column of a view - 10-17-2007 , 10:35 AM

Re: Rename column of a view - 10-17-2007 , 10:40 AM

Re: Rename column of a view - 10-17-2007 , 10:44 AM