<div>
that's right, in Oracle8i you have to use dbms_lob package. <br />
<br />
<br />
SQL&gt; SELECT * FROM A WHERE dbms_lob.instr(&lt;column&gt;,'&lt;<wbr />search_str<wbr />ing&gt;',1,1)<wbr />&gt;0;<br />
<br />
hope this helps<br />
<br />
<br />
<br />
<br />

</div>


that's right, in Oracle8i you have to use dbms_lob package.


SQL> SELECT * FROM A WHERE dbms_lob.instr(<column>,'<search_string>',1,1)>0;

hope this helps






<div>
That helped a lot. Could you make it case-INsensitive too?<br />

</div>


That helped a lot. Could you make it case-INsensitive too?


<div>
<div class="content wysiwyg-content">
In Oracle 9 I could use the LIKE operator on CLOB objects, but it doesn't seems to work in Oracle 8.<br />
<br />
Is there an alternative way to do it in Oracle 8 ?<br />
<br />
example: select * from article where bodyText LIKE '%TEST%'<br />
<br />
Batalf
</div>
</div>


In Oracle 9 I could use the LIKE operator on CLOB objects, but it doesn't seems to work in Oracle 8.

Is there an alternative way to do it in Oracle 8 ?

example: select * from article where bodyText LIKE '%TEST%'

Batalf

Oracle8 - LIKE OPERATOR ON CLOB

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.