Can’t get your SQL History or Snippets panel to open? Before version 4.0, we would frequently advise users to close SQL Developer, go into their user settings folder and delete the’windowinglayout.xml’ file and then restart SQL Developer.
This would force SQL Developer to re-create the desktop view and bring everything back to the defaults.
That’s annoying and it should be easier.
So in version v4.0, you can simply ask SQL Developer to re-sort itself.
I realize this is a very short post, and I feel that I’ve cheated you a bit, so here’s a bonus, if completely unrelated tip:
Bonus Tip: Find DB Object Search Results Easier to Read
Based on some feedback, we added a little tweak for the newly designed Find DB Object in version 4.0. In the next EA drop, you’ll be able to quickly expand and collapse the schemas and object type tree nodes. So if you’re searching across 20 schemas, you can quickly see which ones have ‘hits’ and dive into exactly what you want to inspect.
Just right-click on either a schema or object type node and choose the collapse or expand option.
Yes, I’m talking about things you don’t have access to yet. Yes, we’re working on another EA update for version 4.0. No, I can’t tell you when it will be out. Soon.