【PL/SQL】动态sql实例

实例

select substr(i_op_flag, 0, 1) into v_step from dual; ------------截取一个字
    v_sql := 'UPDATE amldata.t_sus_comment t
     SET t.available_type = ''0''   --------数字值0
   WHERE t.process_id = ''' || i_process_id || '''
     and t.process_step like ''' || v_step ||'__''；  ---------模糊查询
   
    --dbms_output.put_line(v_sql);
    execute immediate v_sql;

execute immediate

如果不拼接上begin，end 仅将两个执行语句拼接执行，会报错
在PL/SQL运行DDL语句
给动态语句传值(USING 子句)

参考文章

ORACLE EXECUTE IMMEDIATE 用法 https://www.cnblogs.com/xwb583312435/p/9056263.html
EXECUTE IMMEDIATE 用法小结 https://blog.csdn.net/wang_zhong_cheng/article/details/81202086?utm_source=blogxgwz5