OraFAQ Forum: Client Tools » Column order not as expected

Home » Other » Client Tools » Column order not as expected (SQL Developer 4.1.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Column order not as expected [message #649593]

Thu, 31 March 2016 10:52

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.

Report message to a moderator

Re: Column order not as expected [message #649594 is a reply to message #649593]

Thu, 31 March 2016 11:15

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Column order not as expected [message #649595 is a reply to message #649594]

Thu, 31 March 2016 11:48

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".

Report message to a moderator