How to rename a table column in Oracle 10g

Question

I would like to know  How to rename a table column in Oracle 10g

User · Answer

suppose supply master is a table  and   SQL gt desc supply master    SQL gt Name  SUPPLIER NO      SUPPLIER NAME  ADDRESS1         ADDRESS2         CITY             STATE            PINCODE     SQL gt alter table Supply master rename column ADDRESS1 TO ADDR  Table altered    SQL gt  desc Supply master   Name                     -----------------------  SUPPLIER NO              SUPPLIER NAME            ADDR              this has been renamed                                        ADDRESS2                 CITY                     STATE                    PINCODE

User · Answer

The syntax of the query is as follows   Alter table  lt table name gt  rename column  lt column name gt  to  lt new column name gt     Example   Alter table employee rename column eName to empName    To rename a column name without space to a column name with space   Alter table employee rename column empName to  Emp Name     To rename a column with space to a column name without space   Alter table employee rename column  emp name  to empName

User · Answer

alter table table name  rename column old column name field name to new column name field name    example  alter table student column name to username

User · Answer

alter table table name rename column oldColumn to newColumn

User · Answer

SQL gt  create table a id number    Table created   SQL gt  alter table a rename column id to new id   Table altered   SQL gt  desc a  Name                                      Null     Type  ----------------------------------------- -------- -----------  NEW ID                                             NUMBER

[oracle] How to rename a table column in Oracle 10g

Examples related to oracle

Examples related to oracle10g