How to handle a single quote in Oracle SQL

by

Use two single-quotes

SQL> SELECT 'D''COSTA' name FROM DUAL;

NAME
-------
D'COSTA

Alternatively, use the new (10g+) quoting method:

SQL> SELECT q'$D'COSTA$' NAME FROM DUAL;

NAME
-------
D'COSTA

More Related Contents:

  1. Escaping ampersand character in SQL string
  2. Oracle SQL escape character (for a ‘&’)
  3. How to insert a string which contains an “&”
  4. How do I limit the number of rows returned by an Oracle query after ordering?
  5. When do I need to use a semicolon vs a slash in Oracle SQL?
  6. LISTAGG in Oracle to return distinct values
  7. Fetch the row which has the Max value for a column
  8. Oracle SQL: Update a table with data from another table
  9. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  10. Using ‘case expression column’ in where clause
  11. SQL Error: ORA-00933: SQL command not properly ended
  12. CASE vs. DECODE
  13. Convert a string date into datetime in Oracle
  14. WHERE IN condition not accepting String value
  15. Check if current date is between two dates Oracle SQL
  16. Benefits Of Using SQL Ordinal Position Notation?
  17. Unordered results in SQL
  18. Oracle Dynamic Pivoting
  19. create custom function for date difference excluding weekends and holidays in oracle sql
  20. What is it exactly a BLOB in a DBMS context
  21. Custom Order in Oracle SQL
  22. How do I list all tables in a schema in Oracle SQL?
  23. oracle sql: update if exists else insert [duplicate]
  24. Compare Strings ignoring accents in SQL (ORACLE)
  25. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  26. Subtracting Dates in Oracle – Number or Interval Datatype?
  27. Retrieve Oracle last inserted IDENTITY
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Why are aggregate functions not allowed in where clause
  30. Insert into from CTE

Leave a Comment