随机抽取记录的方法代码

文章作者 100test 发表时间 2007:10:24 12:56:59
来源 100Test.Com百考试题网

我们来看看随机抽取记录的方法，以下代码以抽取4条为例。
create table t as 0select * from all_objects where rownum <= 5000.
set timing on
0select object_name, object_id
from ( 0select object_name, object_id
from t
where object_name like ’%%’
order by dbms_random.random )
where rownum <= 4.

0select object_name, object_id
from ( 0select object_name, object_id
from t sample ( 1 )
where object_name like ’%%’
order by dbms_random.random )
where rownum <= 4.