Message-Id: <10599.115467@fatcity.com> From: "Weerd Kirsten, E.C. de" Date: Thu, 24 Aug 2000 15:58:01 +0100 Subject: RE: Alain, Thanx a lot, this was exactly what I was looking for !!! Greets, Kirsten > -----Original Message----- > From: SAURY Alain [SMTP:ASAURY@recherche.loreal.com] > Sent: Thursday, August 24, 2000 3:30 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: > > The CONTAINS clause is only available if you have created an Intermedia > index on the LONG column (for Oracle 7) or LOB (for Oracle 8). See the > Intermedia help for more. > > Other than that, you can fetch the long in a PL/SQL variable of type LONG > and use ' IF long_var LIKE '. That works. (Dont know if it is limited to > 32 K though) > > Alain SAURY > > > > ERROR at line 1: > ORA-00920: invalid relational operator > > > -----Original Message----- > > From: Tripathi Amit [SMTP:Amit.Tripathi@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@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 > > also send the HELP command for other information (like > subscribing). > > -- > > Author: Tripathi Amit > > INET: Amit.Tripathi@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@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