Re: Create table syntax query

because you almost never should be creating a table in a stored procedure, you should be using a preexisting table (either temporary or otherwise).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message
news:a6d06107.0207040653.606b91da_at_posting.google.com...


> > doh. of course that would work.

> > still shouldn't do it though.

>

> For what reason?

>

> Rene

>

> > > create table tblTest as select rownum+499 testdata from all_objects a,

> > > all_objects b, all_objects c where rownum <= 40001;