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';
Oracle 创建表的存储过程
最新推荐文章于 2024-08-06 11:48:43 发布