title: PL/SQL, how to escape single quote in a string?
body: <p>In the Oracle PL/SQL, how to escape single quote in a string ? I tried this way, it doesn't work. </p>
  
  <pre><code>declare
    stmt varchar2(2000);
  begin
    for i in 1021 .. 6020
    loop
      stmt := 'insert into MY_TBL (Col) values(\'ER0002\')';
  
      dbms_output.put_line(stmt);
      execute immediate stmt;
      commit;
    end loop;
  exception
    when others then
      rollback;
      dbms_output.put_line(sqlerrm);
  end;
  /
  </code></pre>