Author Topic: Repositioning columns in ORACLE?  (Read 96 times)

0 Members and 1 Guest are viewing this topic.

Offline h2obubbler

  • Full Member
  • *
  • Posts: 228
  • Karma: +0/-0
  • Life is like a box of chocolate.
    • View Profile
Repositioning columns in ORACLE?
« on: April 06, 2010, 11:17:23 PM »
 Hi, Is there a way to change the order of the columns in a table? I know that you can change the name via using the COL$ dictionary table. Is there also a sneaky way like that to change the position the faster way?

Thanks thanks.

Techronnati | where technology never sleeps

Repositioning columns in ORACLE?
« on: April 06, 2010, 11:17:23 PM »

Mountain View

Offline MoneyRepublic

  • Full Member
  • *
  • Posts: 165
  • Karma: +0/-0
    • View Profile
Re: Repositioning columns in ORACLE?
« Reply #1 on: April 06, 2010, 11:18:14 PM »
Updating the dictionary is not a good option.
create a new table with CTAS and recreate your constraints etc.
or
Just use a view.
But, why do you want to change the columns?

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
114 Views
Last post August 24, 2008, 04:33:09 PM
by h2obubbler
0 Replies
122 Views
Last post November 11, 2008, 04:51:17 AM
by Corps
0 Replies
127 Views
Last post November 14, 2008, 09:22:46 AM
by MrSpecialist
0 Replies
62 Views
Last post July 25, 2010, 02:48:47 PM
by h2obubbler
0 Replies
64 Views
Last post December 14, 2016, 10:13:40 AM
by MrSpecialist

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.