How to rename a table column in Oracle 10g

Question

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

Answer 1

SQL> create table a(id number); Table created. SQL> alter table a rename column id to new_id; Table altered. SQL> desc a Name Null? Type ----------------------------------------- -------- ----------- NEW_ID NUMBER 

Answer 2

The query syntax is as follows:

 Alter table <table name> rename column <column name> to <new column name>; 

Example:

 Alter table employee rename column eName to empName; 

To rename a column name without a space to a column name with a space:

 Alter table employee rename column empName to "Emp Name"; 

To rename a column with a space in the column name without a space:

 Alter table employee rename column "emp name" to empName; 

Answer 3

 alter table table_name rename column oldColumn to newColumn; 

Answer 4

suppose supply_master is a table and

 SQL>desc supply_master; SQL>Name SUPPLIER_NO SUPPLIER_NAME ADDRESS1 ADDRESS2 CITY STATE PINCODE SQL>alter table Supply_master rename column ADDRESS1 TO ADDR; Table altered SQL> desc Supply_master; Name ----------------------- SUPPLIER_NO SUPPLIER_NAME ADDR ///////////this has been renamed........////////////// ADDRESS2 CITY STATE PINCODE 

Answer 5

alter table table_name rename the column old_column_name / field_name to new_column_name / field_name;

ex: change the column name of the student table for the username;