Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple condition check using decode

563066Mar 29 2007 — edited Mar 31 2007
HI 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2007
Added on Mar 29 2007
11 comments
10,873 views