“Between” CASE and DECODE

Here is a select statement that demonstrates the following:

1. Use of CASE to do a “between” logic.
2. Use of DECODE with SIGN to do a “between” logic.

3. How easy and clear to use CASE as compared to using DECODE.

   (more…)

Filed in Oracle with Comments Off | Tags: case, decode, function, sign

---