oracle

[thavamaniyan]

how to change column name from existing table

[debasisdas]

You can do that only if you are using oracle version 10g.
That is not supported in any prior version.

[Mala232]

Here is the syntax


SQL> alter table <tablename> rename column <old columnname> to <new columnname>;

eg:

alter table test rename column ename to empname;

Good Luck
mala