Batch Delete ORACLE table stored procedures

Batch deletion of ORACLE table stored procedures often requires deletion of some tables during database management, but manual deletion is time-consuming and laborious. You can modify and use the following stored procedures according to the conditions. Declare Cursor cur is select table_name from all_tables where owner = 'xjg' AND TABLE_NAME LIKE 'xjg % '; rs cur % rowtype; www.2cto. combegin for rs in cur loop begin execute immediate 'drop table' | rs. table_name; dbms_output.put_line (rs. table_name); end loop; end;
From mails2008