[PL\SQL] Select a random row from a database table
There is some way to select a random record or row from a database table.
SELECT col1, col2, col3 FROM (SELECT * FROM tcard SAMPLE(1) ORDER BY dbms_random.VALUE)
WHERE branch = 1
CANCELDATE > SYSDATE
AND ROWNUM <= 100);

Note: dbms_random is not true random number generator, just pseudo-random.