It is possible, though, to use functions from the dbms_lob
package in SQL. There are the usual sorts of things
like 'instr()' and 'substr()' that can be used in SQL
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Richard Armstrong wrote in message
<978657729.9750.0.nnrp-12.9e9809ca_at_news.demon.co.uk>...
>John,
>
>I don't think you can search LONGs and
>CLOBs using ordinary SQL operators (e.g WHERE ARTICLE_TEXT LIKE
'%keyword%')
>so it might be worth considering interMedia and Oracle 8.1.6.
>
Received on Fri Jan 05 2001 - 03:18:15 CST
