当前位置:数据库 > Oracle >>

oracle取随机结果测试

oracle取随机结果测试
 
create table t as select * from all_objects where rownum <= 5000;

select object_name, object_id
from ( select object_name, object_id
from t
where object_name like '%%'
order by dbms_random.random )
where rownum <= 4;


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


create table tt(ss number(10));

declare
 v_out number(3);
 i     number(10);
begin
  i := 1;
  while i <= 10000 loop
  begin 
    insert into tt values(i);
    i := i + 1;
  end;
  end loop;
  --dbms_output.put_line(v_out);
end;
/
commit;

select dbms_random.random from dual;

select * from (select * from tt order by dbms_random.random) where rownum<11;

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,