sravee123

 Profile Answers by sravee123 

• Jun 10th, 2008

 

ALTER TABLE table_name RENAME COLUMN old_name to new_name;

Ex: ALTER TABLE employee RENAME COLUMN eno to empno;

nandk.sharma

 Profile Answers by nandk.sharma 

• Jun 10th, 2008

 

ALTER TABLE TABLE_NAME RENAME COLUMN OLD_NAME TO NEW_NAME;

alter table table_name rename

column old_name to

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 20th, 2008

 

ALTER TABLE TABLENAME RENAME COLUMN OLDCOLUMNNAME TO NEWCOLUMNNAME

[CODE]
SQL> DESC EMP;
 Name                            Null?    Type
 ------------------------------- -------- ----
 EMPNO                           NOT NULL NUMBER(4)
 ENAME                                    VARCHAR2(10)
 JOB                                      VARCHAR2(9)
 MGR                                      NUMBER(4)
 HIREDATE                                 DATE
 SAL                                      NUMBER(7,2)
 COMM                                     NUMBER(7,2)
 DEPTNO                                   NUMBER(2)

SQL>  ALTER TABLE EMP RENAME COLUMN HIREDATE TO JOINDATE;

Table altered.

SQL> DESC EMP
 Name                            Null?    Type
 ------------------------------- -------- ----
 EMPNO                           NOT NULL NUMBER(4)
 ENAME                                    VARCHAR2(10)
 JOB                                      VARCHAR2(9)
 MGR                                      NUMBER(4)
 JOINDATE                                 DATE
 SAL                                      NUMBER(7,2)
 COMM                                     NUMBER(7,2)
 DEPTNO                                   NUMBER(2)
[/CODE]

krishna9231

 Profile Answers by krishna9231 

• Jul 6th, 2008

 

In ORACLE 9i ,no OPTION FOR CHANGING COLUMN NAME.If you want dispaly as like column nameeg: select empno,ename "EMPLOYEE NAME" from emp;regardskrishna

sparun1607

 Profile Answers by sparun1607 

• Jul 7th, 2008

 

In 0racle 9i Second Realease there is an option for renaming a column.

janaraj

 Profile Answers by janaraj 

• Aug 12th, 2008

 

For ex..

Select name emp_name from student

kunal066

 Profile Answers by kunal066 

• Aug 27th, 2008

 

ALTER TABLE test RENAME COLUMN col1 TO id;

raghuprasad

 Profile Answers by raghuprasad Questions by raghuprasad

• Sep 1st, 2008

 

We can rename the column name of the table using ALTER TABLE statement.

Eg: ALTER TABLE table_name MODIFY(column_name datatype);

vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy 

• Sep 18th, 2008

 

 we can not change the name of the column in oracle once defined.
 if the column contains null only datatype,widtth we can change
pls recognise this

shriraam

 Profile Answers by shriraam 

• Nov 3rd, 2008

 

Basically you dont have an option or a separate syntax for renaming a column in 9i, 10g.
But there is one such thing called column alias process can be done initially at the time of querying.

rafatullahbs

 Profile Answers by rafatullahbs 

• Mar 18th, 2010

 

alter table tablename rename column oldcoulumnname to newcolumnname;

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Mar 19th, 2010

 

No doubt, alter table table_name rename column column_name to new_columnname ....


shows you the desired result....But mind you if you have installed registered Oracle software on your system, it is not possible to rename column once table is created.

yash thakkar

• Jul 13th, 2011

 

EXEC sp_rename
@objname = 'TableName.OldColumnName',
@newname = 'NewColumnName',
@objtype = 'COLUMN'

namrata

• Sep 14th, 2011

 

above answer not working in oracle 9i.........

karthickrfwin

 Profile Answers by karthickrfwin 

• Sep 22nd, 2011

 

Use this Script for nename particular ColumnName in SqlTable

sp_rename 'TableName.[ColumnNameOld]','[ColumnNameNew]','Column'

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli 

• Jan 12th, 2012

 

Code
ALTER TABLE emp RENAME COLUMN emp_id TO id;