with t as
(select 'a' id from dual union select 'b' from dual union select 'c' from dual union select 'd' from dual union select 'e' from dual)
select * from (select * from t order by dbms_random.value) where rownum<=1
以上语句直接运行即可
with t as
(select 'a' id from dual union select 'b' from dual union select 'c' from dual union select 'd' from dual union select 'e' from dual)
select * from (select * from t order by dbms_random.value) where rownum<=1
以上语句直接运行即可
