How to rename a table column in Oracle 10g

oracle oracle10g

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

oracle oracle10g

The syntax of the query 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 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;

oracle oracle10g

alter table table_name rename column oldColumn to newColumn;

CodeHunter

How to rename a table column in Oracle 10g

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last