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:
Post a Comment