Wednesday, August 24, 2011
Dynamic SQL to drop tables inside a schema
select 'drop table '||table_name||' cascade constraints;' from dba_tables WHERE owner = 'some_owner';
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)