“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.

   Continue reading…

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

---