How to anticipate and escape single quote ‘ in oracle

by

The best way is to use the quoting string literal technique. The syntax is q'[...]', where the “[” and “]” characters can be any of the following as long as they do not already appear in the string.

  • !
  • [ ]
  • { }
  • ( )
  • < >

You don’t have to worry about the single-quotation marks within the string.

Suppose i have a column value as aaa’gh

So you could simply write the SQL as,

SELECT q'[aaa'gh]' FROM DUAL;

It saves a lot of time for developers. Gone are those days when we(developers) used to verify the dynamic sql using dbms_output in development DB, just to make sure things are at place before moving into production.

More Related Contents:

  1. ORA-01843 Not a valid month
  2. Merging two tables in SQL [closed]
  3. Inner join vs Where
  4. How do I do top 1 in Oracle? [duplicate]
  5. Get value based on max of a different column grouped by another column [duplicate]
  6. How to declare variable and use it in the same Oracle SQL script?
  7. How to find the employee with the second highest salary?
  8. Are a CASE statement and a DECODE equivalent?
  9. SQL recursive query on self referencing table (Oracle)
  10. PLS-00428: an INTO clause is expected in this SELECT statement
  11. Why use a JOIN clause versus a WHERE condition?
  12. format interval with to_char
  13. Oracle SQL – Identify sequential value ranges
  14. Equivalent function for DATEADD() in Oracle
  15. Get month name from date in Oracle
  16. OVER clause in Oracle
  17. SQL Error: ORA-00942 table or view does not exist
  18. How to count the number of occurrences of a character in an Oracle varchar value?
  19. PARTITION BY with and without KEEP in Oracle
  20. Is it possible to query a comma separated column for a specific value?
  21. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  22. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  23. How to extract week number in sql
  24. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  25. Using LIKE in an Oracle IN clause
  26. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  27. Search an Oracle database for tables with specific column names?
  28. ORA-01861: literal does not match format string
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment