Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exclusive BETWEEN

William RobertsonMay 1 2015 — edited Jan 2 2018

Very often when working with ranges - especially dates - we want the value that is greater than or equal to the range start and less than the range end so that multiple ranges do not overlap, i.e.

range_start <= n < range_end

which is almost but (frustratingly) not quite a BETWEEN expression.

What I'd like would be optional inclusive and exclusive modifiers for the start and end expressions (defaulting to "inclusive" to preserve the current behaviour), allowing something like

where d between startdate and enddate exclusive

or in full,

where d between startdate inclusive and enddate exclusive

(Or of course any equivalent syntax, if for example where d between startdate and enddate exclusive was felt to be ambiguous as the exclusive keyword might look as though it applied to the entire expression.)

Comments
Post Details
Added on May 1 2015
9 comments
12,890 views