Revision: 16487
Updated Code
at August 6, 2009 06:00 by kamilch
Updated Code
-- drop all tables in current schema declare table_name varchar2(30); cursor usertables is select * from user_tables where table_name not like 'BIN$%'; begin for next_row in usertables loop execute immediate 'drop table ' || next_row.table_name || ' cascade constraints'; end loop; end; /
Revision: 16486
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 6, 2009 05:56 by kamilch
Initial Code
-- drop all tables in current schema declare table_name varchar2(30); cursor usertables is select * from user_tables where table_name not like 'BIN$%'; begin for next_row in usertables loop execute immediate 'drop table ' || next_row.table_name || ' cascade constraints'; end loop; end; /
Initial URL
Initial Description
Initial Title
Drop all tables in Oracle
Initial Tags
Oracle
Initial Language
PL/SQL