Escaping single quote in PLSQL

by

I do this sort stuff a fair bit (usually generating insert/update statements).

You just need to use the replace function to turn all the ' into ''. i.e. Change it to:

str_comment:='COMMENT ON COLUMN '||rec.table_name||'.'||rec.column_name
            ||' IS '''||REPLACE( rec.description,'''','''''')||'''; ' ;

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. PL/SQL, how to escape single quote in a string?
  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. ways to avoid global temp tables in oracle
  11. Split function in oracle to comma separated values with automatic sequence
  12. check if “it’s a number” function in Oracle
  13. ORA-06508: PL/SQL: could not find program unit being called
  14. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  15. SQL*Plus how to accept text variable from prompt?
  16. SQL Fiddle Output Error
  17. Why doesn’t PL/SQL respect privileges granted by Roles?
  18. oracle PL/SQL how to calculate range ip for IPv6 cidr
  19. if (select count(column) from table) > 0 then
  20. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  21. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  22. What is the algorithm used by the ORA_HASH function?
  23. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  24. passing in table name as plsql parameter
  25. Reading clob line by line with pl\sql
  26. BEGIN – END block atomic transactions in PL/SQL
  27. Why cannot I create triggers on objects owned by SYS?
  28. No more data to read from socket
  29. automating rollback script oracle
  30. How do I get column datatype in Oracle with PL-SQL with low privileges?

Leave a Comment