日期:2014-05-17 浏览次数:20696 次
DECLARE sqltext varchar(500); month varchar(5); BEGIN select to_char(to_char((trunc(sysdate, 'mm')- interval '2' month),'mm'), '09') into month from dual; sqltext:='truncate table XPrice_SRChannelHis_'||month||' drop storage'; dbms_output.put_line (sqltext); execute immediate sqltext; end; ORA-03291: ??????? - ?? STORAGE ??? ORA-06512: ? line 8