Hi Piotr,

> I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL
> query (without extra table or view).
>
> Something what after running query looks like:
>
> List_of_numbers
> -----------------------
> 1
> 2
> 3
> 4
> 5

You can write a selectable stored procedure to achieve that, with the number of rows as a parameter.

Or use EXECUTE BLOCK.


Cheers,
Paul Vinkenoog