OraFAQ Forum: Server Administration » How to change column name of any table in oracle without modifying actual table

Home » RDBMS Server » Server Administration » How to change column name of any table in oracle without modifying actual table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to change column name of any table in oracle without modifying actual table [message #375191]

Fri, 03 August 2001 08:35

Amol
Messages: 12
Registered: June 2001

Junior Member

Hi,
I want to change the name of column of one table without modifying it. How to do that ?

Report message to a moderator

Re: How to change column name of any table in oracle without modifying actual table [message #375197 is a reply to message #375191]

Fri, 03 August 2001 09:11

Cindy
Messages: 88
Registered: November 1999

Member

Here this is from Oracle FAQ:
http://www.orafaq.org/faqsql.htm

Can one rename a column in a table?
No, this is listed as Enhancement Request 163519. Workarounds:
1. rename t1 to t1_base;
create view t1 <column list with new name> as select * from t1_base;

2. create table t2 <column list with new name> as select * from t1;
drop table t1;
rename t2 to t1;

Report message to a moderator

Previous Topic:	Re: How to change column name of any table in oracle without modifying actual table
Next Topic:	HELP WITH AUTOTRACE STATISTICS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 11:14:46 CDT 2024