CREATE OR REPLACE PROCEDURE "PRO_GZ_ZTCREATETABLE" (ZTBH in int) is
sqlStr varchar2(1000);
begin
sqlStr := 'create table T_NEWGZ_GZFF_BAK_ZT' || ztbh ||
' (
BMID varchar2(200) ,
Code varchar2(100) ,
BMMC varchar2(50)
)';
execute immediate sqlStr;
end;
sqlStr varchar2(1000);
begin
sqlStr := 'create table T_NEWGZ_GZFF_BAK_ZT' || ztbh ||
' (
BMID varchar2(200) ,
Code varchar2(100) ,
BMMC varchar2(50)
)';
execute immediate sqlStr;
end;
sqlStr varchar2(1000);
begin
sqlStr := 'create table T_NEWGZ_GZFF_BAK_ZT' || ztbh ||
' (
BMID varchar2(200) ,
Code varchar2(100) ,
BMMC varchar2(50)
)';
execute immediate sqlStr;
end;
as
begin
declare sqlStr varchar2(1000);
begin
sqlStr := 'create table T_NEWGZ_GZFF_BAK_ZT' || ztbh ||
' (
BMID varchar2(200) null,
Code varchar2(100) null,
BMMC varchar2(50) null
)';
execute immediate sqlStr;
end;
end;
is
declare sqlStr varchar2(1000);
begin
sqlStr := 'create table T_NEWGZ_GZFF_BAK_ZT' || ztbh ||
' (
BMID varchar2(200) null,
Code varchar2(100) null,
BMMC varchar2(50) null
)';
execute immediate sqlStr;end;