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