declare
i integer;begin
select count(*) into i from user_tables where table_name = 'YY_TEST';
if i > 0 then
dbms_output.put_line('该表已存在!');
execute immediate 'DROP TABLE YY_TEST';
else
dbms_output.put_line('该表不存在');
end if;
execute immediate 'CREATE TABLE YY_TEST(id int primary key,name varchar(50),username varchar(50))';
end;