Oracle CLOB Search – how to find a string pattern using where clause

Came across a need to search Oracle clob content for particular words pattern and was wondering how to do it. Well, it's simple using DBMS_LOB package. The where clause would look like:

Where DBMS_LOB.instr(myClobColumn, 'my data pattern here') > 0

For more info on usage, refer here.

Love coding!