Multiple condition check using decode
563066Mar 29 2007 — edited Mar 31 2007HI All,
I have a new requirement and need your help .
need to check the follwing condidtions in a sql statement.
a) we have a status coulmn which has values like 1,2,3,4,5,6,7 based on some other coulmns . this status will keep on repeat based on values in other coulmns.
each status will update one by one. ( ie, update of status1 to status2 takes 3 min of time ) and status4 to status5 takes 10 min of time.
i need to select the rows which exceeds the above time limit.
ie )
if Time taken for (status1 to status2) change is > 3min then select that row.
and if Time taken for (status14 to status5) change is > 10min then select that row.