Rename column name

[ganeshshegde]

How to rename the column?
i entered "alter table student_19104 rename student_marks to stud_marks"
But it's giving error "missing PARTITION or SUBPARTITION keyword "

[debasisdas]

that feature is available only in oracle version 10g.

[gintsp]

How to rename the column?
i entered "alter table student_19104 rename student_marks to stud_marks"
But it's giving error "missing PARTITION or SUBPARTITION keyword "

You have invalid syntax i.e. lack keyword column

17:10:58 SQL> desc z
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------------
 FF                                        NOT NULL VARCHAR2(10 CHAR)

17:58:39 SQL> alter table z rename column ff to gg;

Table altered.

Elapsed: 00:00:00.21
17:59:27 SQL> desc z
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------------
 GG                                        NOT NULL VARCHAR2(10 CHAR)

17:59:30 SQL>

It is all written in oracle docs and you can find them http://tahiti.oracle.com

Gints Plivna

[Mala232]

The syntax is

SQL> Alter table <tablename> rename column <old columnname> to <newcolumnname> ;

good luck
mala

[ganeshshegde]

Hey,thanks it's working.