Rename Column

[amits]

Is it possible to rename a column in a Oracle table in 8i or 9i.
Thanks

[sjadhavdba]

create a new column . update it from first and drop it.

[Tarry]

NO!(until 8i atleast).

[ronnie]

undefine newname
undefine oldname
undefine ownername
undefine tablename
update SYS.COL$ c
set c.NAME = '&&newname'
where c.NAME = '&&oldname'
and c.OBJ# in (select o.OBJ# from SYS.OBJ$ o, SYS.USER$ u
where o.OWNER# = u.USER# and u.NAME = '&&ownername' and
o.NAME = '&&tablename');


btw its not supported by oracle :-)


You will have to bounce the database after doing this for you to see the change


Hope this Helps