Re: where clause pb

 my query is too long but like yours modified

select num_rows from dba_tables
 where table_name in (select table_name from user_tables where  last_analyzed is not null)
 or table_name like 'S%'

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> a écrit dans le message : 3be6a80d$0$8514$ed9e5944_at_reading.news.pipex.net...
> whats the query?
> "gil guerillot" <gil.guerillot_at_ratp.fr> wrote in message
> news:9s68nr$34t$1_at_gotix.reseau.ratp...
> > My query is a little different:
> >
> > the 2 conditions are on the same field but not yours!!
> >
> >
> >
> > Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> a écrit dans le
> > message : 3be69341$0$8511$ed9e5944_at_reading.news.pipex.net...
> > > Yes you can certainly write in this format for example
> > >
> > > select num_rows from dba_tables
> > > where table_name in (select table_name from user_tables where
> > last_analyzed
> > > is not null)
> > > or owner = 'SYSTEM'
> > >
> > > which returns results on my system when run as a user with dba privs.
> > >
> > > perehaps you could post your actual sql and any error messages.
> > >
> > >
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission Uk
> > >
> > > "gil guerillot" <gil.guerillot_at_ratp.fr> wrote in message
> > > news:9s5sc4$2q4$1_at_gotix.reseau.ratp...
> > > > I have a SQL query like this:
> > > >
> > > >
> > > > Select *
> > > > from table1
> > > > where condition1 in(select field1 from table2
> > > > where condition2=parameter1)
> > > > or condition1 like parameter2
> > > >
> > > >
> > > > Is it possible like this ?
> > > > result never appear
> > > >
> > > >
> > > >
> > >
> > >
> >
> >

>
> Received on Mon Nov 05 2001 - 09:09:04 CST