Default folder order

[greg.mccarty]

I'm sure I've missed this, but how do I set the order by for the default (i.e. plsql dev defined) folders?

In particular, the package bodies.

Thanks,
GregM

 

[Marco Kalter]

If you go to Tools > Browser Folders, you can rearrange the default folders in any way you like, show or hide folders, create your own query based or static folders, and create sub folders.

 

[greg.mccarty]

Oops, sorry, badly asked questions.

I understand the reordering of the folders themselves. What I'm looking for is reordering the contents of each folder.

For instance, when I see the packages within a package folder, I'd like to see the packages in alphabetical order.

I notice that when looking at the folder definitions, the options (where you would change the order by) are grayed.

Is there a way to do this?

 

[Stew Stryker]

Greg,

This sounds like a local problem you're having, as my packages within a single schema are always sorted alphabetically. I think you'd have a riot by all users if they weren't!

Is it possible you're seeing packages across multiple schemas and you want them sorted alpha but ignoring the schema name?

Best,

Stew

 

[Marco Kalter]

For user-defined folders you define the sort order in the query definition.

For system folders the sort order is defined by the current browser filter. Just like user-defined folders, each filter has a where clause and order by clause that is applied to each system folder.

 

[Stew Stryker]

Marco,

Thanks for that useful bit of information.