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!

Searching inside a BLOB

YoavMar 24 2015 — edited Mar 24 2015

Hi,

I need to search inside BLOB segment for specific string.

I have tried two options , but non of them return row.

select ...

from ....

where dbms_lob.instr(my_blob, utl_raw.cast_to_raw('/PROD-NP-2009Version/Shared/Connections/Database'))>0

select ...

from ....

where dbms_lob.instr(my_blob, utl_raw.cast_to_raw('/PROD-NP-2009Version/Shared/Connections/Database'),1,1)>0

I am not sure that the string is exists , but would like to get your advise which option is should use future searches

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2015

Added on Mar 24 2015

3 comments

8,305 views