RE: IN MISTERY

From: Alvarez, Carlos <CAlvarez_at_uniFON.com.ar>
Date: Mon, 15 May 2000 13:27:55 -0300
Message-Id: <10498.105663@fatcity.com>

Hola Sergio,=20

        try this:

> select lista_tipo_publi from lista_tipo_publi where
> lista_tipo_publi
> in (select tipos from lista_pautas
> where id_pauta=3D'6')

>=20
I dont see why you are using the replace. In fact, this causes the Oracle will search for lista_tipo_publi =3D ('palabras', 'negritas', = 'sin
cargo breves')

> I get 0 rows as result. Any idea about that. Is the IN clause
> working
> wrong.

>=20
The IN (as the rest of Oracle) works well. Dont blame the base soft.=20

HTH=20 Carlos.=20

> ----------
> De: sergio[SMTP:smoriano_at_sicon.net]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Lunes 15 de Mayo de 2000 12:04
> Para: Multiple recipients of list ORACLE-L
> Asunto: IN MISTERY

>=20

> Hi all

>=20
> I have the next query with the in clause, and it doesn=B4t works, =
any
> idea?.

>=20


>  I f i execute the query,

>     select'''||replace(tipos, ', ' , ''', ''')||'''' from =

lista_pautas

> where id_pauta=3D'6'
> i get the result:

>=20

> 'palabras', 'negritas', 'sin cargo breves'

>=20


> With the query,

>     select lista_tipo_publi from lista_tipo_publi where

> lista_tipo_publi
> in ('palabras', 'negritas', 'sin cargo breves')
> i get the result:

>=20

> 4
> 9
> 50

>=20

> But if I try with the quey:

>=20


>     select lista_tipo_publi from lista_tipo_publi where

> lista_tipo_publi
> in
> (select'''||replace(tipos, ', ' , ''', ''')||'''' from lista_pautas
> where id_pauta=3D'6')

>=20

> I get 0 rows as result. Any idea about that. Is the IN clause
> working
> wrong.

>=20

> Is there another way to do the same query without the IN clause.

>=20

> Thanks for your responses,

>=20

> Bye.

>=20

> --=20
> Author: sergio
> INET: smoriano_at_sicon.net

>=20


> 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 Mon May 15 2000 - 11:27:55 CDT