PL/SQL 删除对象删除数据库中所有的表declare2CURSOR cur_pro is select object_name from user_objects w
PL/SQL 删除对象 删除数据库中所有的表
declare 2 CURSOR cur_pro is select object_name from user_objects where object_type='PROCEDURE'; 3 BEGIN 4 FOR v_name IN cur_pro LOOP 5 execute immediate 'drop PROCEDURE' || v_name.object_name; 6 END LOOP; 7 end; 8 /
