oracle - SQL to generate a list of numbers from 1 to 100 -

Using the DUAL table, how do I get a list of numbers from 1 to 100?

Your question is difficult to understand, but if you type 1 to Want to select a number of 100 , then this should do the trick:

  Select from DoubleClick with Roulelem R & lt; = 100