Batch drop and batch flashback in oracle

Oracle batch drop and batch flashback raise the question: if you do not write a stored procedure, drop can only generate one table at a time. In this case, how can I delete multiple tables at a time? Solution: Use select statements to query all the tables you want to delete and combine these statements into SQL statements that can be executed. Copy these statements and paste them to the following. Naturally, all the statements are deleted. Www.2cto.com asked the following question: how can I restore the deleted table? Solution: All the deleted tables will be stored in the recycle bin at 10 Gb, which can be restored in the recycle bin and restored in batches. SQL code block -- batch Delete table table_name user_tables [SQL] SQL> select 'drop table' | table_name | ';' from user_tables where table_name like 't_% '; www.2cto.com 'droptable' | TABLE_NAME | ';' ------------------------------------------ drop table T_STU; drop table T_SCORE; drop table T_COUSE; SQL> drop table T_STU; table dropped SQL> drop table T_SCORE; Table dropped SQL> drop table T_COUSE; table dropped SQL> -- batch restore table original_name recyclebin [SQL] SQL> select 'flashback table' | original_name | 'to before drop; 'From recyclebin where original_name like 't_% '; 'flashbacktable' | returns rows flashback table T_STU to before drop; flashback table T_SCORE to before drop; flashback table T_COUSE to before drop; www.2cto.com SQL> flashback table T_STU to before drop; Done SQL> flashback table T_SCORE to before drop; Done SQL> flashback table T_COUSE to before drop; Done