ERROR at line 1:
ORA-00920: invalid relational operator
> -----Original Message-----
> From: Tripathi Amit [SMTP:Amit.Tripathi_at_sisl.co.in]
> Sent: Thursday, August 24, 2000 6:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE:
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Author: Tripathi Amit
> INET: Amit.Tripathi_at_sisl.co.in
>
> 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 Thu Aug 24 2000 - 01:55:56 CDT
