Originally posted by Horace
Does this only apply to 10g, as unfortunately we're productionised on 9i ??
It should work with any release that has DBMS_RANDOM package available (at least from 8i on, I belive).

Of course the specific implementation of
{your_row_source_here} that padders used in the second query could not work prior to 10g, since MODEL clause is not available in pre-10g. But that is not essential for your problem, you simply replace the {your_row_source_here} with your table name.