Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: are create table using stored procedure?
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.orgReceived on Fri Apr 13 2007 - 10:22:59 CDT