Oracle Database Discussions

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!

CHANGE COLUMN ORDER

GolfStar03Jul 5 2011 — edited Jul 5 2011

Hi,

I need to change the column order on a table. Is it possible?

When I say :> desc table_name

it lists the column as follows

col1
col2
col3

But, I need to change the col3 in place of col2 so that it looks like

col1
col3
col2

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2011

Added on Jul 5 2011

#general-database-discussions

5 comments

1,388 views