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