Wednesday, July 22, 2015

Rename the existing Column in Oracle Table from 9iR2



In Oracle9ir2, Oracle provides "alter table" syntax to rename data columns in-place in this form:
alter table
   table_name
rename column
   old_column_name  
TO
   new_column_name;
Here are some examples of Oracle "alter table" syntax to rename data columns.
alter table
   cust_table
rename column
   cust_sex 
TO
   cust_gender;

No comments:

Post a Comment