Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> RE: oracle

RE: oracle

From: jmartin <jmartin_at_rcanaria.es>
Date: Fri, 4 May 2001 14:38:25 +0100
Message-ID: <3af2b043.0@news.ll.iac.es>

I have other question about CLOB and Oracle.

How can I do a dynamic SQL to search for a substring into of CLOB??

I want anything as this:

"SELEC XX, XX FROM YY WHERE CLOB LIKE '%" + string + "%'"

Thank for your answer.

Rayden <tdurlach_at_hotmail.com> escribió en el mensaje de noticias 9cs666$2vt9$1_at_msunews.cl.msu.edu...
> i have a clob field in a table (in ms sql and sybase i can get away with a
> super long ass varchar)...anyway, i am having problems selecting the
 column
> and converting it to a string......anyone have any ideas?
>
>
> --rayden
>
>
Received on Fri May 04 2001 - 08:38:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US