Done for Fun

This thing has no practical purpose :-) maybe some little meaning as yet-another-pivoting-approach.

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.0.0 - Beta

SQL> SELECT ROWNUM                      
  2    FROM TABLE(                      
  3           XMLSEQUENCE(              
  4               XMLQUERY('            
  5                 for $i in 0 to 9    
  6                   return <e>{$i}</e>
  7               ' RETURNING CONTENT   
  8               )                     
  9           )                         
 10         ) tbl                       
 11  /                                  

   ROWNUM
---------
        1
        2
        3
        4
        5
        6
        7
        8
        9
       10

10 rows selected.