Skip to Main Content

SQL Developer

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!

verstion 1.5.1: sort retention - how to permanently disable it??

665147Oct 14 2008 — edited Jan 12 2009
Hi All-
We're using SQL Developer version 1.5.1, and are noticing that when we sort data on a table, the sort is being retained for all subsequent times we access this table. We'd like to disable this.

Problem description:
Here's the version we're using: Version 1.5.1 Build MAIN-5440

I make a database connection, Navigate to a schema, then to tables, click on a table (ex: ACCOUNT), and then click on the Data tab to see all the data. Then I click on SORT, and select ACCOUNT_ID and ascending.

The table will then sort by ACCOUNT_ID in ascending order. If I close the db connection, connect as the same schema (or any other schema that has the account table), navigate to a schema, then to tables, click on the ACCOUNT table and then the Data tab...the data is still being ordered by ACCOUNT_ID in ascending order.

The sort order is being saved.
So far, the only way I've been able to find to clear the sort retention is to do the following: Click on Tools --> Preferences --> Database --> Objectviewer Parameters. In the Data Editor section, click the Clear button.

That works...but it's a lot of steps to take every time a sort is completed.

Is there some setting in SQL Developer that can permanently be set to not save the sort choices??

thanks
-Diana
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2009
Added on Oct 14 2008
8 comments
1,266 views