this runs just fine for me.
what error messages if any are you getting?
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"gil guerillot" <gil.guerillot_at_ratp.fr> wrote in message
news:9s6a24$45d$1_at_gotix.reseau.ratp...
> 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:10:58 CST
