how to change the column's position in table?
483636Apr 16 2006 — edited Feb 20 2013hye all,
how can i change the position of column in the database
for example:
when i do query = "select column_name from all_tab_columns where table_name = upper('table_test')"
this will be the column output - "columnA, columnB, columnC, columnD"
but what i need is output like this : "columnD, columnA, columnB, columnC
i think we have to change the position of the column in the database..so, how can i do that?
thanks~