top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can one rename a column in a table in Oracle 8i?

+1 vote
489 views
How can one rename a column in a table in Oracle 8i?
posted Jun 24, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes

alter table tablename oldname to newcolumn_name;

answer Jun 25, 2015 by Priyadharshini Kunjithapatham
Similar Questions
+1 vote

I am using below statement but i got error.
ALTER TABLE XXXtable
ADD xxx_name varchar2(50) not null;

error message:
ORA-01758: table must be empty to add mandatory (NOT NULL) column

...