Oracle 9 handles these queries:
> for e.g where ename like '%oracle'
just like any other string type, so you shouldn't need to modify a query.

Oracle 8xx may require (I don't know) the use of the DBMS_LOB function library for this. There are INSTR and SUBSTR functions, as well as others. For Oracle 8, try here:
http://www.znow.com/sales/oracle/appdev.816/a76940/toc.htm


HTH,
TIm



> -----Original Message-----
> From: rajmohit.thlluri [mailto:rajmohit.[Email Address Removed] Sent: Friday, January 31, 2003 9:09 AM
> To: LazyDBA.com Discussion
> Subject: RE: problem in accessing lob/long columns
>
>
> I guess u need to user oracle context for that. U got to
> create containers for it.
>
> -----Original Message-----
> From: madhu guntupalli [SMTP:[Email Address Removed] Sent: Friday, January 31, 2003 12:16 PM
> To: LazyDBA.com Discussion
> Subject: problem in accessing lob/long columns
>
>
>
>
> plz tell how to access the content of a long column or
> CLOB of LOB type. i.e searching based on string critera.
>
> for e.g where ename like '%oracle'.
> how can we do it for long or lob columns in sql or pl/sql?
>
> by madhu
>
>
>
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page