Re: where clause pb

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

>

>

>