日期:2014-05-17 浏览次数:20691 次
declare
str_tabprefix varchar2(30);
str_tabsuffix varchar2(30);
str_tabname varchar2(30);
int_exists number;
begin
str_tabprefix := 'imei_imeicount_';
str_tabsuffix := to_char(sysdate, 'yyyymm');
str_tabname := str_tabprefix
------解决方案--------------------
str_tabsuffix;
select count(*) into int_exists from tabs where table_name = upper(str_tabname);
if (int_exists = 0) then
execute immediate 'create table '
------解决方案--------------------
str_tabname
------解决方案--------------------
'(text varchar2(200))';
end if;
end;