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: SQL help

Re: SQL help

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 10 Oct 2005 12:13:14 -0400
Message-ID: <9177895d0510100913v27e5e817w2aacf714d8b7aeac@mail.gmail.com>


with x as (select length(replace(translate('&1','1234567890',' '),' '))+1 c1 from dual)
,y as (select count(*) c2 from t where id in (&1)) select t.*
from t, x a, y b
where id in (&1)
and a.c1 = b.c2
/

Raj

On 10/10/05, Sandeep Dubey <dubey.sandeep_at_gmail.com> wrote:
>
> Hi,
>
> I am having weekend hangover with seemingly simple sql requirement.
>
> create table t(id number);
> insert into t values(1);
> insert into t values(2);
> commit;
>
> I want to query this with an Id set. All values in the set should be
> there to return me any row.
> e.g.
> select * from t where id in (1,2); return 1 and 2
>
> If am serching for 1,2,3 if any one value is missing I should not get any
> data.
> e.g.
> select * from t where id in (1,2,3) should not return any row.
> How to rewrite the above query with (1,2,3) that should not return me any
> row.
> Thanks
>
> Sandeep
> --
> http://www.freelists.org/webpage/oracle-l
>

--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 10 2005 - 11:15:21 CDT

Original text of this message

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