Changing column positions in database
Absolutely,you can change the position of the columns in the table but one thing I would like to know that why you need this concept.Whatever,you have posted and consider such a good thing.
you can chnage the positiojn of columns to make the different copy of the existing table.The query to create a new column would be as follows:
Code:
SQL> create table New_tab as select col_3, col_0, col_1, col_2 from Prev_tab;
SQL> drop table Prev_tab;
SQL> rename New_tab to Prev_tab;
Bookmarks