SQL Developer has had an object search for quite a while, however we decided it wasn’t good enough, so we enhanced it!
You can now search more things, and the search results are easier to work with.
Here’s a quick demo to see it live in action:
How it works
For your your connection, you’ll need to set a few search parameters, the SCHEMAs you want to look into, and then what you want to look for.
By default we search across every SCHEMA. If you uncheck, ‘All Schemas’ it will default to your login user schema.
After that, you need to decide if you want to look for objects of a given name, for their presence in PL/Scope, or to see if they’re mentioned in your database source code.
So if you’re looking for a reference to a VIEW in your PL/SQL source code, you would check the appropriate item in the ‘All Source Lines’ section of the tree. Note that in newer version of SQL Developer, we can now also search your VIEW and Materialized VIEW source as well as your defined RESTful Services.
Now for the ‘cool’ part – the results become a new object navigator. Click on an object in the search results to open it. If it’s a PL/SQL object, we’ll even place the cursor in the first line of the code that matches your search pattern.
Since I published this post, we also added two additional entry points for using the Search:
- main toolbar button (look for the binoculars)
- for Windows, ALT+G on text in a worksheet/code editor
Bonus Feature: Search History
We’ll remember your previous searches and search settings, as you start typing, you’ll see them pop-up if it matches something you’ve searched before.