Message-Id: <10598.115438@fatcity.com> From: Tripathi Amit Date: Thu, 24 Aug 2000 09:36:58 +0530 Subject: RE: Try the clause CONTAINS -----Original Message----- From: Weerd Kirsten, E.C. de [SMTP:Kirsten.deWeerd@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@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@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@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@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@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@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@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@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