The Object Search was greatly enhanced in version 4.x – go read about that here.

Version 3.2.1 included a few tweaks along with several hundred bug fixes. One of those tweaks was the addition of ‘ALL_SOURCE’ as a selection for the Type drop down in the Find Database Object panel.

Scroll ALL the way down to the bottom

Searching the database for your code or objects can be expensive. The ALL_SOURCE view comes in pretty handy when I want to demo how to cancel long running queries or the Task Progress panel – did you know you can manage all of your long running queries here?

Yeah, don’t run this

I pretty much hosed our demo pod at Open World b/c I ran that same query but added an ORDER BY b.TEXT DESC to the query and blew up the TEMP space and filled the primary partition on the image. Fun stuff.

Anyways, where was I going with this? Oh yeah, searching ALL_SOURCE can be expensive. So we took it out of the product for awhile. And now it’s back in. If you select the ‘ALL’ field, it doesn’t actually search EVERYTHING, because that would probably be less than helpful. So if you want to search your PL/SQL objects for a scrap or bit of code, use the ‘ALL_SOURCE’ option in v3.2.1

Click on the search results to go to the code you’re looking for.

Be careful what you search for. Just like any query, it could take awhile.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

7 Comments

  1. John Garmon Reply

    Is there a way to restrict this to the query currently open, on-screen in Developer?

  2. I’ve been using “Find Database Object” for ages and didn’t realise it can do a code search! It doesn’t seem to search in View source however – is there another option I’ve missed?

  3. Hello Jeff,

    actually you have to click on the search result, no double click.

    Could youu explain the ‘Usage’ selection a little bit? II don’t see any difference in result.

    Best regards,

    Joop

Reply To Joop Cancel Reply