Oracle 创建表的存储过程

create or replace procedure mytestdrop as v_cnt  number; begin   select count(*) into v_cnt from user_tables where table_name = 'MYTESTDROPTABLE';   if v_cnt>0   then   dbms_output.put_line('该表存在！');   execute immediate  'drop table MYTESTDROPTABLE';   end If;   dbms_output.put_line('不存在就创建表！');   execute immediate 'create table MYTESTDROPTABLE tablespace MYDB_SPACE as select * from GETSYSDATE';