Re: NO ORDER option

aschneid_at_cmp.com writes in article <6ivedi$dq2$1_at_nnrp1.dejanews.com> ...
>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??

You can use UNION ALL instead of UNION

Valery Yourinsky Received on Thu May 14 1998 - 00:00:00 CEST