Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get entire SQL statement for a matching text string, from DBA_SOURCE?

Junaid2OracleJan 26 2018 — edited Jan 28 2018

If we try to find/search a text string from a DB stored PL/SQL program, we could find it using following query:

    select * from dba_source where upper(text) like '%HELLO%';

So if we got 3 records as output of above query, how do we fetch entire 3 PL/SQL or SQL statements  where search string 'HELLO' is found.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2018
Added on Jan 26 2018
14 comments
2,879 views