用dbms_random从固定的数中随机取数

别人原一个问帖,我用这个方法解决,觉得有点笨啦,哈哈

with tt as (select 1 B from dual
            UNION ALL
            select 4 b from dual
            UNION ALL
            select 8 b from dual
            UNION ALL
            select 9 b from dual
            UNION ALL
            select 12  from dual)
select b
from (select b,row_number() over(order by dbms_random.value) rn from tt) 
where rn=1  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12391917/viewspace-265365/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12391917/viewspace-265365/