Trying to understand a WHERE clause statement
Posted on 2014-02-24
Let's say I have a table with columns Col1, Col2, ColBeginDate and ColEndDate. vDate is a parameter to the procedure.
If I have this in the WHERE clause:
WHERE vDate between ColBeginDate(+) AND ColEndDate(+)
What does this mean? I would think it would give all rows where vDate is between those two dates and all rows where vDate is not between those dates. If that is the case, why do we need to include the WHERE clause?
Does it mean that whatever rows are returned by the SELECT and after all other WHERE clause conditions are satisfied, a filter will be placed on the result as follows:
vDate between ColeBeginDate and ColEndDate. So only take those rows.
Appreciate an answer.