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).
Received on Wed Aug 23 2000 - 02:19:41 CDT