doh. of course that would work.
still shouldn't do it though.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message
news:Xns9240EADB5DD71gnuegischgnueg_at_130.133.1.4...
> > 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.
>
>
> Not sure if you're after this sql stmt:
>
> create table tblTest as select rownum+499 testdata from all_objects a,
> all_objects b, all_objects c where rownum <= 40001;
>
>
> --
> Recherchen im schweizerischen Handelsregister:
> http://www.adp-gmbh.ch/SwissCompanies/Search.php3
>
Received on Thu Jul 04 2002 - 03:10:04 CDT
