Here is a select statement that demonstrates the following:

Use of CASE to do a “between” logic. Use of DECODE with SIGN to do a “between” logic. How easy and clear to use CASE as compared to using DECODE.