Create table syntax query

I need to create tables on the fly with sequential numbers from, for example, 500 to 40,500 in it.

The table definition is

CREATE TABLE tblTest(testdata NUMBER(6));

Presently I am populating the table in a stored procedure using a LOOP. The word on the street is that I can create a table & populate the testdata column with the 40,000 numbers in it with a single SQL statement.

Is this right?

Thank you
Spencer Received on Wed Jul 03 2002 - 07:21:16 CDT