PL/SQL, how to escape single quote in a string?

by

You can use literal quoting:

stmt := q'[insert into MY_TBL (Col) values('ER0002')]';

Documentation for literals can be found here.

Alternatively, you can use two quotes to denote a single quote:

stmt := 'insert into MY_TBL (Col) values(''ER0002'')';

The literal quoting mechanism with the Q syntax is more flexible and readable, IMO.

More Related Contents:

  1. What is the replacement of cursor foreach in oracle pl/sql?
  2. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  3. Printing the value of a variable in SQL Developer
  4. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  5. Passing an array of data as an input parameter to an Oracle procedure
  6. Convert comma separated string to array in PL/SQL
  7. UTL_FILE.FOPEN() procedure not accepting path for directory?
  8. Oracle stored procedure with parameters for IN clause
  9. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  10. Get resultset from oracle stored procedure
  11. Oracle PL/SQL – How to create a simple array variable?
  12. ways to avoid global temp tables in oracle
  13. Split function in oracle to comma separated values with automatic sequence
  14. check if “it’s a number” function in Oracle
  15. ORA-06508: PL/SQL: could not find program unit being called
  16. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  17. Create Pivot view in SQL from a SQL table
  18. SQL*Plus how to accept text variable from prompt?
  19. SQL Fiddle Output Error
  20. Why doesn’t PL/SQL respect privileges granted by Roles?
  21. oracle PL/SQL how to calculate range ip for IPv6 cidr
  22. if (select count(column) from table) > 0 then
  23. Can We use threading in PL/SQL?
  24. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  25. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  26. What is the algorithm used by the ORA_HASH function?
  27. passing in table name as plsql parameter
  28. Reading clob line by line with pl\sql
  29. How to use parameters in a ‘where value in…’ clause?
  30. BEGIN – END block atomic transactions in PL/SQL

Leave a Comment