How to change column name of any table in Oracle?

No comments
Sometimes we might need to change column name in table, to do so

alter table <table name> rename column <column name to be changed> to <desired column name>

For example if you want to change column name from D_ID to DEPT_ID of DEPARTMENT table


alter table DEPARTMENT rename column D_ID to DEPT_ID;

No comments :

Post a Comment