Search This Blog

Wednesday, February 26, 2025

Search String Inside Oracle Database Objects SQL

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

No comments:

Post a Comment

Error From Interactive Grid - Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row locking.

Error: Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row ...