CODE EXAMPLE FOR SQL

connect by query in oracle

SELECT rownum FROM DUAL CONNECT BY level<=10;