Hi Everybody,
I want to change structure of table in oracle DB version 11gR2.
What I need to do is to rename all columns and then change there data type.
Kindly requesting you to suggest the way I can achieve it in single sequel statement instead of writing two alter table statements , one to rename columns and one to modify columns.