The WebSphere Runbook
WAS notes
Saturday, 8 December 2012
Drop all tables for a specified user in Oracle
Begin
for a in (select table_name from user_tables) loop
execute immediate ('drop table '||a.table_name||' cascade constraints');
end loop;
End;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment