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!

Search string has values with lower and upper case !

S567Apr 21 2020 — edited Apr 21 2020

Hi Team,

I work on Oracle 11g database.

I am searching for code where this string is used (can be package ,proc,function) in my DB using DBA_SOURCE.

The string is like CDA___CDCA_PostStore_PreGold4.csv with below sqls none of it is working..Can you help

SELECT * FROM DBA_SOURCE

WHERE lower(text) LIKE '%poststore%' ;

SELECT * FROM DBA_SOURCE

WHERE upper(text) LIKE '%CDA%' ;

Thanks,

Added on Apr 21 2020

6 comments

2,324 views