Re: array

At some point you are going to have to write it out. Otherwise you are dropping ALL tables.

Sounds to me like you are overcomplicting a simple task.

Daniel Morgan

Philip Morrow wrote:

> I need to loop through several tables and drop them. I'm using an execute
> immediate statement inside a stored procedure. I'd like to create an array
> of the table names to be droped and have the loop check for the exsistance
> of the table and drop it if it exsists. How can I create an array of the
> table names. If it's not possible is there another way to accomplish this
> task without writing out each statement with different table name.
>
> Phil
Received on Tue Mar 12 2002 - 12:14:40 CST