Re: Q: query with OR

from oracle 7.2 in sqlplus, and from oracle 7.3 in PL/SQL cursor:

select count(*) from
 (select 'x' from tablename
   where fieldone = 'value1'
  union all
  select 'x' from tablename
   where fieldone = 'value2')
where rownum < 100000;

if less than oracle 7.2, create a view for the subselect. Received on Wed Feb 12 1997 - 00:00:00 CST