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

Home -> Community -> Usenet -> c.d.o.misc -> Re: where clause pb

Re: where clause pb

From: gil guerillot <gil.guerillot_at_ratp.fr>
Date: Mon, 5 Nov 2001 16:29:05 +0100
Message-ID: <9s6b7f$8gg$1@gotix.reseau.ratp>


ORA-01002 fetch out of sequence

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> a écrit dans le message : 3be6ac37$0$8505$ed9e5944_at_reading.news.pipex.net...
> 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:29:05 CST

Original text of this message

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