Cute ROWNUM trick

SELECT DBMS_RANDOM.VALUE
FROM DUAL
CONNECT BY ROWNUM<=1000;

SELECT ROWNUM
FROM DUAL
CONNECT BY ROWNUM<=10;

Advertisements