Re: drop and create tables in PL/SQL

You must use dynamic SQL (DBMS_SQL package is useful to do it).

					Greetings
						Marcin

On 30 Dec 1999, 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 Thu Dec 30 1999 - 08:37:22 CST