ORA-01002 fetch out of sequence
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:40:44 CST
