Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help with multiple BETWEEN statements

Re: help with multiple BETWEEN statements

From: Yvonne G <hlngus_at_hotmail.com>
Date: 12 Jan 2003 21:04:14 -0800
Message-ID: <d999b872.0301122104.3344fe44@posting.google.com>


thanks to those for correcting me:

however, when there is only 1 between statement the query comes back quickly.

when there are multiple OR clauses, the query just hangs and eats up system resources. What is happening?

SELECT A from table1
> where rate = 'abc'
> and code between '0100' and '0199'
> OR code between '4000' and '4499'

thanks again.

hlngus_at_hotmail.com (Yvonne G) wrote in message news:<d999b872.0301120842.66c00282_at_posting.google.com>...
> Can someone provide an assist with compound BETWEEN syntax?
>
> I want to enforce the following:
>
> SELECT A from table1
> where rate = 'abc'
> and code between '0100' and '0199'
> and code between '4000' and '4499'
> and code between '7000' and '7999'
> and code between '9000' and '9499'
> etc, etc.
>
> What is the proper syntax?
>
> Thanks.
Received on Sun Jan 12 2003 - 23:04:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US