Display every instance of a found term in Object Search

Toad for Oracle & DevOps Toolkit
1

I came to Toad for Oracle after many years using Oracle SQL developer. There is still one thing I use it for and that is its code search. Where object search in Toad returns the package/procedure the search value is found in, the SQL Developer search returns the text of the line, the line and col for each instance of the search term and I can click on the line I want and it will take me to the source code.

This is what a chunk of a search looks like

  • Prog_matrix_utl in PROG_MATRIX_UTL Body at line 103, col 70 
    •     07.21.2025 munser add p_rr_type_select, p_courses_select and p_docs_select in PROG_MATRIX_UTL Body at line 871, col 44

    •     p_docs_select         in varchar2, in PROG_MATRIX_UTL Body at line 876, col 70

    •         p_docs_select         => p_docs_select, in PROG_MATRIX_UTL Body at line 904, col 16

    •        or p_docs_select is not null then in PROG_MATRIX_UTL Body at line 906, col 20
2

Thanks Michelle for using our Forums. Could you please confirm if you’re referring to Toad for Oracle or Toad for SQL Server product? Thanks.

3

I updated my suggestion! Toad for Oracle is what I meant. Thanks!

4

Hi Michelle,

In Toad, if you double-click package from the search result, a window will open which shows the package source and all occurrences of the search term highlighted. You can then hit F3 to jump through them.

-John

1 Like