Oracle Random Query

Tag: c A CTI Line name table

1.

SELECT * FROM (SELECT * to tablename ORDER by Dbms_random.value) where rownum< N;

Note: Dbms_random is a package that can generate random numbers or strings. Value () is the most commonly used, the use of value () generally has two species, the first function value return number; This usage has no parameters and returns a numeric value with 38 digits, ranging from 0.0 to 1.0, but excluding 1.0. The following example: Dbms_output.put_line (Round (dbms_random.value*100)); The second value has two parameters, the first is the lower limit, the second is the upper limit, and the number between the lower bound and the upper bound is generated, but not the upper bound, as follows: Dbms_output.put_line (Trunc (Dbms_random.value (1,101)));

2.

SELECT * FROM TableName sample (3) where rownum < 4;