Skip to content

Instantly share code, notes, and snippets.

@plehr

plehr/gist:9553c1f24a5aff56a7d4e977e3105351

Created November 29, 2019 10:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save plehr/9553c1f24a5aff56a7d4e977e3105351 to your computer and use it in GitHub Desktop.
Save plehr/9553c1f24a5aff56a7d4e977e3105351 to your computer and use it in GitHub Desktop.
Download ZIP
ORACLE clear database
Raw
gistfile1.txt
BEGIN
FOR table_ IN (SELECT table_name FROM all_tables WHERE OWNER='MS2') LOOP
execute immediate 'DROP TABLE ' || table_.table_name || ' CASCADE CONSTRAINTS';
END LOOP;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment