Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Drop ALL Tables!!How??

Drop ALL Tables!!How??

From: Cincout <checkin_at_hongkong.com>
Date: Mon, 28 Sep 1998 22:54:40 +0800
Message-ID: <360FA330.8F7CFB6A@hongkong.com> 





I am new to PL/SQL, I have tried to write a script to drop all tables as
follow but enter a runtime error. 


What wrong is It?


Thanks a lot!! 



Begin 


for curTable in (select table_name from user_tables) loop 


         DROP TABLE CURTABLE.TABLE_NAME; 

end loop; 


END;

Received on Mon Sep 28 1998 - 09:54:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US