Saturday, November 28, 2009

Rename a column name in oracle

The following command can be used to rename a column name.


Lets say the EMPLOYEE table has the following structure

E_name varchar2(100)
E_no number

I need to change the E_no as Employee_no then

ALTER TABLE EMPLOYEE RENAME COLUMN E_no as Employee_no

I think there's no way to rename multiple columns in a single statement

No comments:

Powered By Blogger