rrudnik
5/13/2015 - 2:36 PM
show V_VAL value that can never be less than V_MIN or more than V_MAX.
show V_VAL value that can never be less than V_MIN or more than V_MAX.
SELECT GREATEST (LEAST (V_VAL, V_MAX), V_MIN) from dual show V_VAL value that can never be less than V_MIN or more than V_MAX.
SELECT GREATEST (LEAST (V_VAL, V_MAX), V_MIN) from dual