Home » RDBMS Server » Server Administration » Re: How to change column name of any table in oracle without modifying actual table
Re: How to change column name of any table in oracle without modifying actual table [message #375196] Fri, 03 August 2001 09:10
Amol
Messages: 12
Registered: June 2001
Junior Member
The query given by u(
SELECT YOUR_FIELD1 AS NEW_FIELD1,
YOUR_FIELD2 AS NEW_FIELD2,
YOUR_FIELD3 AS NEW_FIELD3,
YOUR_FIELD4 AS NEW_FIELD4
FROM YOUR_TABLE
)just shows data of that column with new name but it does not change actual name of column in database. I want to change name of actual column in database.
How to do that?

Report message to a moderator

Previous Topic: Help with " Adding Constraint" script
Next Topic: How to change column name of any table in oracle without modifying actual table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 10:26:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.