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;
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;
cust_table
rename column
cust_sex
TO
cust_gender;
No comments:
Post a Comment