oracle迁移到达梦中下面的这个语句要怎么改呢
BEGIN
v_sql_SC_ENTITY_SC_RE:=‘truncate table SC_ENTITY_SC_RE’;
execute immediate v_sql_SC_ENTITY_SC_RE;
v_sql_SC_ENTITY_EXCEPT_RE:=‘truncate table SC_ENTITY_EXCEPT_RE’;
execute immediate v_sql_SC_ENTITY_EXCEPT_RE;
v_sql_SC_ENTITY_BLACK_RE:=‘truncate table SC_ENTITY_BLACK_RE’;
execute immediate v_sql_SC_ENTITY_BLACK_RE;
达梦支持动态sql,
declare
v_sql_SC_ENTITY_SC_RE VARCHAR2(2000);
v_sql_SC_ENTITY_EXCEPT_RE VARCHAR2(2000);
v_sql_SC_ENTITY_BLACK_RE VARCHAR2(2000);
BEGIN
v_sql_SC_ENTITY_SC_RE:=‘truncate table SC_ENTITY_SC_RE’;
execute immediate v_sql_SC_ENTITY_SC_RE;
v_sql_SC_ENTITY_EXCEPT_RE:=‘truncate table SC_ENTITY_EXCEPT_RE’;
execute immediate v_sql_SC_ENTITY_EXCEPT_RE;
v_sql_SC_ENTITY_BLACK_RE:=‘truncate table SC_ENTITY_BLACK_RE’;
execute immediate v_sql_SC_ENTITY_BLACK_RE;
end