Searching Your PL/SQL Source with Oracle SQL Developer

thatjeffsmith SQL Developer 7 Comments

Tell Others About This Story:

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.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 7

    1. thatjeffsmith Post
      Author
  1. 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?

    1. thatjeffsmith Post
      Author
  2. 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

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *