NO ORDER option

From: <aschneid_at_cmp.com>
Date: 1998/05/08
Message-ID: <6ivedi$dq2$1_at_nnrp1.dejanews.com>#1/1


I am trying to do the following statement:

select * from products
where lower(product) like '%name%' and product_type='S' UNION
select * from products
where lower(product) like '% name %' and product_type='S'

but the list being returned is not select1 + select2 - it is (select1+select2) ordered by the primary key. Isn't there a way to say no order in oracle??

Thanks

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 08 1998 - 00:00:00 CEST

Original text of this message