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: drop and create tables in PL/SQL

Re: drop and create tables in PL/SQL

From: Kel Bahi <kel_bahi_at_yahoo.com>
Date: Sun, 02 Jan 2000 05:09:50 GMT
Message-ID: <386EDDD8.91A5516@yahoo.com>


I have not done any creates, but I have don drops by using dynamic sql within PL/SQL.
/Kel

Dennis wrote:

> Dear all,
> I attempt to drop and create a table in PL/SQL, but PL/SQL doesn't
> support DDL commands. The Oracle-supplied package (DBMS_DDL) doesn't do
> this job either. Do you have any ideas? Thanks in advance.
>
> Dennis
Received on Sat Jan 01 2000 - 23:09:50 CST

Original text of this message

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