SQL> desc t;
Name Type Nullable Default Comments
---- -------------- -------- ------- --------
ID VARCHAR2(10) Y
VAL VARCHAR2(1000) Y
SQL> alter table t rename column val to vals;
Table altered
SQL> desc t;
Name Type Nullable Default Comments
---- -------------- -------- ------- --------
ID VARCHAR2(10) Y
VALS VARCHAR2(1000) Y
Name Type Nullable Default Comments
---- -------------- -------- ------- --------
ID VARCHAR2(10) Y
VAL VARCHAR2(1000) Y
SQL> alter table t rename column val to vals;
Table altered
SQL> desc t;
Name Type Nullable Default Comments
---- -------------- -------- ------- --------
ID VARCHAR2(10) Y
VALS VARCHAR2(1000) Y