var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Return random records.
What is the best method in Oracle to return N random records from a table?
try using the sample cluase in the select
Only problem with it is it returns a percentage of records rather than N records.
Gotta have N, where N is dynamic between 10 and 50.
select * from
( select * from table order by dbms_random.value )
where rownum <= :n;
Thanks again, Andrew. I will give that a shot.