Thursday, May 26, 2011

Alter column name in oracle

Alter column name in oracle.
Here I have a table named Employee, I want to rename column - Name to FullName.
First we can create a table with name Employee.
create table Employee
Id int primary key ,
Name varchar2(100)

Next we can write the alter table statement to alter the column name. Please see the example.
RENAME COLUMN Name to FullName;

No comments: