Try the clause CONTAINS
-----Original Message-----
From: Weerd Kirsten, E.C. de [SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
Sent: Wednesday, August 23, 2000 1:01 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:
I've tried to do a LIKE, with the following result :
ERROR at line 2:
ORA-00932: inconsistent datatypes
> -----Original Message-----
> From: Ron Rogers [SMTP:RROGERS_at_galottery.org]
> Sent: Tuesday, August 22, 2000 6:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:
>
> You might get duplicate rows to the query if the text is repeated
in the
> field. To eliminate dups use the distinct clause;
> spool the output to a file for review later.
> Select number_field from table_name where long_field like
'%TEXT%';
> be prepared to go to lunch if the table is large.
> HTH
> Ron Rogers (ROR)
>
> >>> Kirsten.deWeerd_at_Oranjewoud.nl 08/22/00 09:38AM >>>
> Question :
>
> I've got a table with a number and a LONG-field. This Long
contains text.
> Someone asks me if and how he can select all numbers where the
> corresponding
> long-field text contains a certain word.
>
> Using Oracle 7.2.3 and I haven't got a clue.
>
> Help ?
>
> Greets,
>
>
> Kirsten
> --
> Author: Weerd Kirsten, E.C. de
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access / Mailing
Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
may
> also send the HELP command for other information (like
subscribing).
>
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access / Mailing
Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
may
> also send the HELP command for other information (like
subscribing).
--
Author: Weerd Kirsten, E.C. de
INET: Kirsten.deWeerd_at_Oranjewoud.nl
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
Received on Wed Aug 23 2000 - 23:06:58 CDT
