Home -> Usenet -> comp.databases.oracle -> Re: Remove all tables for user with one SQl statement?

Re: Remove all tables for user with one SQl statement?

From: Chuck <skilover_nospam_at_softhome.net>
Date: Mon, 09 Jan 2006 15:59:32 GMT
Message-ID: <Xns97466FD2C832skiloversofthomenet_at_127.0.0.1> 






"Jan Doggen" <j.doggen_at_BLOCKqsa.nl> wrote in news:43a2ee48$0$11062
$e4fe514c_at_news.xs4all.nl:



> Hi

> 

> How can I remove all tables

> UserName.TblNam1

> UserName.TblNam2

> UserName.TblNam3

> etc

> 

> with one SQL statement?

> 

> Thanks in advance

> Jan

> 

> 





An anonymous PL/SQL block...




begin

executute immediate 'drop table UserName.TblNam1';
executute immediate 'drop table UserName.TblNam2';
executute immediate 'drop table UserName.TblNam3';


end;


/



Or you could write a "dropalltables" stored procedure and run that.
Received on Mon Jan 09 2006 - 16:59:32 CET












Original text of this message