Searching for Text within Oracle Stored Procedures

Question

I need to search through all of the stored procedures in an Oracle database using TOAD  I am looking for anywhere that the developers used MAX   1 instead of the NEXTVAL on the sequence to get the next ID number   I ve been doing SQL Server for years and know several ways to do it there but none are helping me here   I ve tried using   SELECT   FROM user source WHERE UPPER text  LIKE   blah     Results are returned but only for my default schema and not for the schema I need to be searching in   I also tried the below but it just errors  SELECT   FROM SchemaName user source WHERE UPPER text  LIKE   blah

User · Answer

If you use UPPER text   the like   lah   will always return zero results  Use   LAH

User · Answer

I allways use UPPER text  like UPPER   blah

User · Answer

SELECT   FROM ALL source WHERE UPPER text  LIKE   BLAH     EDIT Adding additional info    SELECT   FROM DBA source WHERE UPPER text  LIKE   BLAH     The difference is dba source will have the text of all stored objects  All source will have the text of all stored objects accessible by the user performing the query  Oracle Database Reference 11g Release 2  11 2   Another difference is that you may not have access to dba source

[sql] Searching for Text within Oracle Stored Procedures

Examples related to sql

Examples related to oracle

Examples related to stored-procedures

Examples related to full-text-search

Examples related to toad