Re: How to query LONG fields?

From: Sharkie <sharkie2_at_my-deja.com>
Date: Mon, 27 Mar 2000 19:13:57 GMT
Message-ID: <8bobt4$kfl$1@nnrp1.deja.com>

you can use ConText search like:

<sql snippet>
SELECT column_names
FROM your_table
WHERE CONTAINS(your_long_column,'your search string')>0; </sql snippet>

but your DBA has to set up ConText server for this table/column first. I don't know if there is a different way.

In article <954107046.16898.1.pluto.c30bfbb6_at_news.demon.nl>, "Gerard van Wilgen" <Gerard_at_gvwilgen.demon.nl> wrote:
> Paul heeft geschreven in bericht

<8u7dOOK8eVpDuPvxAUEi4paNWfo7_at_4ax.com>...
> >How *do* you search for text in LONG fields? I know SELECTS can't
> >contain LONGS. I assume this is a FAQ. Is there a FAQ of these sort
of
> >questions?
>
> Shajnas al mi ke la nura metodo estas krei PL/SQL-kodon por konverti
> donajhojn en LONG-formato al VARCHAR-formato kaj sekve trasherci la
tekston
> per la INSTR-funkcio.
>
> Tamen, mi devas konfesi ke mi estas ankorau Oracle-komencanto, do eble
estas
> pli bonaj metodoj.
>
> Gerard van Wilgen
>
>

--
If the human brain were so simple
that we could understand it,
we would be so simple we couldn't.
-Makes Sense... don't it?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 27 2000 - 13:13:57 CST