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
