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

Home -> Community -> Usenet -> c.d.o.misc -> Re: are create table using stored procedure?

Re: are create table using stored procedure?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 13 Apr 2007 08:22:59 -0700
Message-ID: <1176477772.844079@bubbleator.drizzle.com>


lakshmanankg_at_gmail.com wrote:
> hai every body
> are u known this question
> are you create table using stored procedure?

You can do so using either Native Dynamic SQL or the DBMS_SQL built-in package.

But before you engage in a bad practice just because you can, or just because that is how it is done in other unrelated products check out Global Temporary Tables and read at least one of Tom Kyte's books from cover-to-cover.

The fact that you CAN do something doesn't mean you should NOT.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Apr 13 2007 - 10:22:59 CDT

Original text of this message

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