Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE:

RE:

From: Weerd Kirsten, E.C. de <Kirsten.deWeerd_at_Oranjewoud.nl>
Date: Thu, 24 Aug 2000 15:58:01 +0100
Message-Id: <10599.115467@fatcity.com>


Alain,

        Thanx a lot, this was exactly what I was looking for !!!

        Greets,

   Kirsten

> -----Original Message-----
> From: SAURY Alain [SMTP:ASAURY_at_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_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
> > 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
Received on Thu Aug 24 2000 - 09:58:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US