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?

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:
  


Current Time: Tue Dec 24 07:21:42 CST 2024