问题: 在SQL中直接执行语言
UPDATE D_VOL SET QYR='个人', syscode=FB_MD5TOSTR(to_char (sysdate,'yyyymmddmiss')||dbms_random.value) WHERE QYR IS NULL如果要写到存储过程要如何写:
v_updatevol2:='UPDATE D_VOL SET QYR='个人', syscode=FB_MD5TOSTR(to_char (sysdate,'yyyymmddmiss')||dbms_random.value) WHERE QYR IS NULL’
execute immediate v_updatevol2;
v_updatevol2语句要如何写才能使用特殊符号 ’与||
UPDATE D_VOL SET QYR='个人', syscode=FB_MD5TOSTR(to_char (sysdate,'yyyymmddmiss')||dbms_random.value) WHERE QYR IS NULL如果要写到存储过程要如何写:
v_updatevol2:='UPDATE D_VOL SET QYR='个人', syscode=FB_MD5TOSTR(to_char (sysdate,'yyyymmddmiss')||dbms_random.value) WHERE QYR IS NULL’
execute immediate v_updatevol2;
v_updatevol2语句要如何写才能使用特殊符号 ’与||
execute immediate v_updatevol2;