oracle在存储过程中,如何删除和创建表?

Question

我这样写总是报错,高人指教 第一次写存储过程,请指教create or replace procedure cswzsync.replace_table_wz_property is 
begin -- truncate table wz_property 
truncate table wz_property; -- drop table wz_property 
drop table wz_property; -- Create table wz_property 
create table WZ_PROPERTY 
( 
PROPERTYID VARCHAR2(32) not null, 
ADDRESS VARCHAR2(100), 
RELEASEDATE DATE, 
IDCARD VARCHAR2(50), 
HOUSEHOLDER VARCHAR2(100), 
AREA NUMBER(12,2) 
) 
tablespace USERS 
pctfree 10 
initrans 1 
maxtrans 255 
storage 
( 
initial 1M 
minextents 1 
maxextents unlimited 
); 
end replace_table_wz_property;

Answer 1

execute immediate 'drop table wz_property';

Answer 2

问题太简单,刚刚自己已经查到了
create or replace procedure replace_table_wz_property
authid current_user
as
str1  varchar2(1000);
str2  varchar2(1000);
str3  varchar2(5000);beginstr1 := 'truncate table wz_property';
str2 := 'drop table wz_property';
str3 := 'create table WZ_PROPERTY
       (
          PROPERTYID  VARCHAR2(32) not null,
                        ADDRESS     VARCHAR2(100),
                          RELEASEDATE DATE,
                            IDCARD      VARCHAR2(50),
                              HOUSEHOLDER VARCHAR2(100),
                                AREA        NUMBER(12,2)
                                )
                                tablespace USERS
                                  pctfree 10
                                    initrans 1
                                      maxtrans 255
                                        storage
           (
           initial 1M
           minextents 1
           maxextents unlimited
                                                        )   ';
execute immediate str1;
execute immediate str2;                                                        
execute immediate str3;                                                        
end replace_table_wz_property;