Home

How to write an inline view with a single column containing an array of numbers in the range 1..n?

Thu, 2006.06.08 - 14:48 — müzso
I just found the following in an article at AskTom ... Laughing out loud

It's a perfect example for the fact that simpler is better. Smile

I've read many times the following solution for the problem:
SELECT
  rownum as seq
FROM
  all_objects
WHERE 1 = 1
  AND ROWNUM <= 100

I was always reluctant to use this approach since the all_objects view utilizes a number of underlying tables, a lot of resources for this little task (or at least a lot of resources for my taste).

The solution in Tom's article uses a hierarchical query on the DUAL table. What a brilliant idea! Laughing out loud
SELECT
  rownum as seq
FROM dual
CONNECT BY
  LEVEL <= 100