PLSQL deletes all tables under a user
1. PLSQL logs in to user An and opens a SQL Window window.
2. Build the command to delete all tables
Select 'drop table' | | table_name | | 'purge' from user_tables
Or
Select 'drop table' | | table_name | |'; 'from user_tables
Note: adding 'purge'' means permanent deletion is unrecoverable
3. Open a Command Window window and execute all the SQL copies built above.
Note: if there is a primary key association, continue to perform steps 2 and 3 until there is no result in the query 2.
