Re: Re: sql script delete all tables

From: teen <s4012051_at_student.uq.edu.au>
Date: 21 Mar 2003 02:19:28 GMT
Message-ID: <b5dsrg$pt0$1@bunyip.cc.uq.edu.au>

>OR,
>
>SELECT 'drop table '||tname||' from tab ; ' ;

Am I meant to replace ||tname|| with the table name? Or is that some kind of command?

>
>Then copy and paste...

Ahh yes, that will kind of defeat the purpose of making a script :/

I was thinking along the lines of something like DROP TABLE * WHERE TABLE_NAME IN (SELECT TABLE_NAME FROM USER_TABLES); obviously i'm unsure if the syntax is correct.. i'm soon installing oracle on this system so i'll be able to play around a bit.

thanks for any hints I can get :P Received on Thu Mar 20 2003 - 20:19:28 CST