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;
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;
Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
ReplyDeleteWorkday Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training