Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Jul 25, 2006

Changing Column Names in Oracle

Oracle does not have a mechanism by which you directly change column names. But this workaround is quick and efficient.

Consider TableA:


COLUMN_1 NUMBER
COLUMN_2 VARCHAR2(500)
COLUMN_3 DATE
You want to change it to TableB:

NEW_COLUMN_1 NUMBER
NEW_COLUMN_2 VARCHAR2(500)
NEW_COLUMN_3 DATE
then use the following SQL.

CREATE TABLE TableB (NEW_COLUMN_1, NEW_COLUMN_2, NEW_COLUMN_3) AS SELECT (COLUMN_1, 
COLUMN_2, COLUMN3) FROM TableA;
TableB will have the new columns as expected.

MS Sridhar
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap