关于随机函数的问题！急！急！

[guanhai]

请教各位高手，在ORACLE中如何生成一个随机函数？急！

[bzszp]

dbms_random.value(1,n)

[happylyc83]

select * from (select * from ur_table order by sys_guid()) where rownum<n;或者
select * from (select * from ur_table order by dbms_random.value) where rownum<n;
sys_guid(),dbms_random.value都是系统函数！这个语句可以随机抽取

[dinya2003]

select dbms_random.random from dual

select dbms_random.value from dual

都可以生成随机数的,

[whitecloud80]

select trunc(dbms_random.value(1,300)) from tm_fasvk

1~300之间的随机整数