Code searching isn’t new for version 4.2. It’s not even new for version 4.1, or v4.0…but what IS new, is that some folks consider the SQL behind their VIEW objects to be ‘code.’

So, for version 4.2, you can say, search my PL/SQL source AND search the SQL behind my views.

Just check the ‘All Views’ toggle.

You’ll notice there’s an option to add wildcards around your search term for the ‘Code’ category – that’s useful when searching object names in your data dictionary and also for references to that object in your source code.

Hit ‘Go’, and voila.

Clicking on the search result will open the object.

It’s not exactly easy to search on views, the code behind a view is stored in a LONG column. But, it’s not impossible.

You can see how we do it by using the Statements panel.

Ah, so that’s how they do it…

Don’t forget the ‘Trick!’

My favorite way to access the search.

Select, alt+g, and ‘Go’ 🙂
thatjeffsmith
Author

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

14 Comments

  1. Hi,
    I want to search for any code that contains a certain expression. Code in a Scheduler-Program which is included in “program_action” (line 4) isn’t found.
    Are there certain exceptions of code that is excluded from the search even if the code checkbox is selected and ORDS is un-selected?

    • thatjeffsmith

      I doubt the scheduler definitions are included in the search, if you look at the SQL ran, you can see what’s covered and not (view – log – statements panel)

  2. Hi,
    Is there any shortcut to view source behind any Function/Procedure/Package etc. without browsing through the objects for example in TOAD, simply write object name in the editor and by pressing F4 will display the source text.

    • Thx a lot, yes it works fine but surprisingly Ctrl+Click doesn’t work if previous statement in the editor
      doesn’t contain a semicolon (;) unless this is the only statement in the editor e.g. consider the below 2 stmts
      1. select * from AAA
      2. select * from BBB
      No issue with table AAA but Ctrl+Click wouldn’t work on table BBB unless put a ; after sttm 1

      Both Ctrl+Click and Shift+F4 doesn’t work if the object in single quotes

      But still this is manageable, thx for the quick tips.

      select * from dba_objects where lower(object_name) = ‘abc’

  3. Sadly, I just discovered it doesn’t seem to search materialised view source (all_mviews) . I am still on 4.2

  4. Anonymous Coward Reply

    I have SQL developer 17.2, in the “Code” section there is a new option labeled “ORDS”. I don’t know what this is, but if it’s selected my searches never return any results.

  5. A great feature I had not noticed with the EAs. Seems pretty fast,too. Thanks!

  6. Frank Feng Reply

    Shortcut Alt+G is not available in Mac version of Sql Developer 4.2 , and I cannot configure it because there is no entry “Find DB Object” in “Preference” / “Shortcut Keys” configuration page.

Write A Comment