9i has the dbms_redefinition package which can perform an in-place renaming
of a column (amongst other things). All prior versions require you to
'create table as select', which is expensive. In all versions, too, you can
create a view on the base table... the view can have column names defined
which have not the slightest relation to the name of the columns in the
underlying table.
Regards
HJR
"Ingrid" <Ing001256_at_colombia.fr> wrote in message
news:ac6p46$aef$1_at_news5.isdnet.net...
>
> hi
>
> Since wich version Oracle allows to rename a column in a table ?
>
>
> thanx.
>
>
Received on Sat May 18 2002 - 21:00:42 CDT
