Search This Blog

Saturday, October 21, 2023

Search by Keyword from All Oracle Database Objects

Search by keyword from Oracle Database Objects.

select owner, type, name, line, text 

from dba_source where 1 = 1

and text like '%TEXT YOU ARE LOOKING FOR%'

order by owner, type, name;


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;