CREATE OR REPLACE PROCEDURE "HISUSER"."CREATE_TABLE_MZ_GH_ND"
(name in varchar2) as
i number;
begin
select count(*) into i from user_tables where table_name=name;
if i<=0 then
execute immediate 'create table name as select * from mz_gh_nd where 1=2';
end if;
end;
(name in varchar2) as
i number;
begin
select count(*) into i from user_tables where table_name=name;
if i<=0 then
execute immediate 'create table name as select * from mz_gh_nd where 1=2';
end if;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货