Monday, October 12, 2009

Random value generate by query

1.

select QUOTMESG
-- into vstr
from SYQUTMSG sample(25)
where rownum =1;

2.

SELECT empno
FROM emp
ORDER BY DBMS_RANDOM.VALUE

No comments: