Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 0 - expire
- 1 - approval
- 2 - pending
- 3 - counting
- 1 - approval ,
- 3 - counting,
- 0 - expire
- 2 - pending.
- -- sampe of data from 0 to 3
- SQL> with t1(x) as(
- 2 select level - 1
- 3 from dual
- 4 connect by level <= 4
- 5 )
- 6 select * -- actual query
- 7 from t1
- 8 order by case x
- 9 when 0 then 'expire'
- 10 when 1 then 'approval'
- 11 when 2 then 'pending'
- 12 when 3 then 'counting'
- 13 end
- 14 ;
- X
- ----------
- 1
- 3
- 0
- 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement