ORA-00904: Invalid identifier when using dbms_random.value

Question

This article here suggests using dbms_random.value to select random values from a table. My query ``` select value1, value2 from (select value1, value2 from my.table order by dbms_random.value) where rownum <100; ``` Gives me ``` Error at Command Line:2 Column://column after the 'by'). Error report: SQL Error: ORA-00904: : invalid identifier 00904. 00000 - "%s: invalid identifier" ``` Any suggestions?

Accepted Answer

Insufficient user priviledges. Don't have access to the dbms_random package.

ORA-00904: Invalid identifier when using dbms_random.value

Solution

Problem