Re: How to change/alter column name

"Sönke Petersen" <sk.petersen_at_gmx.de> wrote in message news:<b83ifv$i19$1_at_news.mch.sbs.de>...
> Hello,
> how can I change (in an easy manner) the column name of on Oracle table?
> Regards,
> Sönke

If you are using 9i (R2, look like) , just use "RENAME COLUMN".

SQL> desc tyu

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 C1                                                 VARCHAR2(2)
 C2                                                 NUMBER(2)

SQL> alter table tyu rename column c2 to col2;

Table altered.

SQL> desc tyu

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 C1                                                 VARCHAR2(2)
 COL2                                               NUMBER(2)

SQL>

• Jusung Yang