Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to change the column's position in table?

483636Apr 16 2006 — edited Feb 20 2013
hye 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~

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2013
Added on Apr 16 2006
35 comments
86,459 views