Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create table syntax query

Re: Create table syntax query

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 4 Jul 2002 21:37:49 +0100
Message-ID: <3d24b21f$0$227$cc9e4d1f@news.dial.pipex.com>


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;
Received on Thu Jul 04 2002 - 15:37:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US