oralce 动态sql 点位符示例

declare 
S varchar2(36); 
E varchar2(20); 
COMMENTGUID nvarchar2(36);

BEGIN
  --赋值
  EXECUTE IMMEDIATE 'select sys_guid() from dual'  into COMMENTGUID;
  --带参数
  EXECUTE IMMEDIATE 'select :1 ,:2 from dual' INTO S,E using 'PILIANG','ddfdfd';
  --数据写入
   EXECUTE IMMEDIATE 'insert into A values (sys_guid(),1, :1, :2)'
        using '004001','1,'||S||','||E;
  --数据更新
  EXECUTE IMMEDIATE 'update B set examineuserid=:1 where id=:2' using 'PILIANG',COMMENTID;
 
END;