dbms_lob.instr

SQL

SELECT DBMS_LOB.INSTR(CSUSERATTACHEDFILE01.FILECONTENT, 'a') AS blobIndexOf
   FROM CSUSERATTACHEDFILE CSUSERATTACHEDFILE01
  WHERE (CSUSERATTACHEDFILE01.CSUSERATTACHEDFILENO=10291)

XML query API

<query alias="testLobIndexOf" projectedClass="com.taleo.akirademo.entity.AttachedFile"  >
    <projections>
        <projection alias="blobIndexOf">
            <lobIndexOf>
                <field path="fileContent"/>
                <string>205465737420</string>
            </lobIndexOf>
        </projection>
    </projections>
    <filterings>
        <filtering>
            <equal>
                <field path="no"/>
                <integer>10291</integer>
            </equal>
        </filtering>
    </filterings>
</query>