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;