From: skilover_nospam@softhome.net   
      
   "Jan Doggen"  wrote in news:43a2ee48$0$11062   
   $e4fe514c@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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)