Range of values SQL statetment

Hi. I would appreciate your help on this: A table tab1 is created as follows: create table tab1 (col1 number, col2 number); insert into tab1 values (1, 10); Is there a way to query this table and get the following resut: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. which is the numbers from col1 (1) to col2 (10).

Thanks.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Oct 03 1998 - 21:48:14 CDT