Oracle储存过程----删除表

1.先创建一个表：

create table test as select * from test_order;

2.写删除表的存储过程

create or replace procedure dropTable(v_table in varchar2) 
is
v_count number(10);
begin
select count(*) into v_count from user_tables where table_name = upper(v_table);
if v_count > 0 then
execute immediate 'drop table ' || v_table ||' purge';
end if;
end dropTable;

3.调用存储过程，删除表test

call dropTable('test');

call dropTable('test');

也可以这样调用:

declare
v_table varchar2(200);
begin
  v_table:='test';
  p_dropTable_ifExists(v_table);
  end;