RENAME COLUMN TABLE VIEW in Oracle

 ALTER TABLE APPLPATH10G RENAME COLUMN old_col TO new_col;

SQL> ALTER TABLE APPLPATH10G RENAME COLUMN HOST1 TO IP1;

Table altered.


SQL> set lines 80

SQL> desc APPLPATH10G
 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------
 FOLDER                                             VARCHAR2(100)
 IP1                                                VARCHAR2(20)
 IP2                                                VARCHAR2(20)
 IP3                                                VARCHAR2(20)
 RWS1                                               VARCHAR2(20)
 RWS2                                               VARCHAR2(20)
 RWS3                                               VARCHAR2(20)


SQL> alter table APPLPATH10G modify rws3 varchar2(20);

Table altered.