Home » SQL & PL/SQL » Client Tools » Column order not as expected (SQL Developer 4.1.2)
Column order not as expected [message #649593] Thu, 31 March 2016 10:52 Go to next message
Pommel
Messages: 2
Registered: March 2016
Junior Member
Hey,

I got a problem with the column order presented by the SQL Developer in the Data tab.
I have deleted a table BETA_F with columns A_ID, PERSON, ORDER, DATE (A_ID's column id is 1, PERSON's 2, ...). Then I deleted BETA_F and created the same table again but so that PERSON has the column_id 1, ORDER 2, DATE 3 and A_ID 4. But the SQL Developer still shows A_ID as the first column in the Data tab even though it's column id is 1.

Does someone know how I make the Data tab show the order of columns the ID's imply?
(Even reopening the SQL Developer doesn't work)

Thanks.
Re: Column order not as expected [message #649594 is a reply to message #649593] Thu, 31 March 2016 11:15 Go to previous messageGo to next message
BlackSwan
Messages: 25793
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

DELETE TABLE does NOT make table go away.

select to_char(sysdate, 'YYYY-MM-DD HH24:MI'), CREATED FROM ALL_OBJECTS WHERE OBJECT_NAME = 'BETA_F';
post results from SQL above
Re: Column order not as expected [message #649595 is a reply to message #649594] Thu, 31 March 2016 11:48 Go to previous messageGo to next message
Pommel
Messages: 2
Registered: March 2016
Junior Member
Yes, sorry. I meant dropping the table. I found the solution for all who are looking for something similar. You can reset all persistent settings by right clicking a column and selecting "Delete persisted settings".
Re: Column order not as expected [message #649598 is a reply to message #649595] Thu, 31 March 2016 12:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Can't happen with SQL*Plus.
Those who live by the GUI will die by the GUI.

Re: Column order not as expected [message #649629 is a reply to message #649598] Fri, 01 April 2016 08:16 Go to previous messageGo to next message
thatjeffsmith
Messages: 71
Registered: July 2009
Location: Raleigh, NC
Member

Last time I checked, your web browser is a GUI.
Re: Column order not as expected [message #649630 is a reply to message #649629] Fri, 01 April 2016 08:31 Go to previous messageGo to next message
Roachcoach
Messages: 1508
Registered: May 2010
Location: UK
Senior Member
Only sometimes Smile
Re: Column order not as expected [message #649634 is a reply to message #649630] Fri, 01 April 2016 09:36 Go to previous message
thatjeffsmith
Messages: 71
Registered: July 2009
Location: Raleigh, NC
Member

ha, nice!
Previous Topic: SP2-0111: Cannot close save file "afiedt.buf"
Next Topic: Drop a hash partition
Goto Forum:
  


Current Time: Wed Jan 17 15:13:10 CST 2018

Total time taken to generate the page: 0.01638 seconds