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';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment