Escaping ampersand character in SQL string

by

Instead of 

node_name="Geometric Vectors \& Matrices"

use 

node_name="Geometric Vectors " || chr(38) || ' Matrices'

38 is the ascii code for ampersand, and in this form it will be interpreted as a string, nothing else. I tried it and it worked.

Another way could be using LIKE and an underline instead the ‘&’ character: 

node_name LIKE 'Geometric Vectors _ Matrices'

The chance that you’ll find some other record too, which is different in only this one character, is quite low.

More Related Contents:

  1. How to insert a string which contains an “&”
  2. When do I need to use a semicolon vs a slash in Oracle SQL?
  3. How do I spool to a CSV formatted file using SQLPLUS?
  4. How do I ignore ampersands in a SQL script running from SQL Plus?
  5. How to handle a single quote in Oracle SQL
  6. Oracle SQL escape character (for a ‘&’)
  7. How to get Oracle create table statement in SQL*Plus
  8. How to kill a running SELECT statement
  9. sqlplus statement from command line
  10. How do I reset a sequence in Oracle?
  11. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  12. Oracle “(+)” Operator
  13. How do you create a temporary table in an Oracle database?
  14. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  15. How to check the maximum number of allowed connections to an Oracle database?
  16. Select without a FROM clause in Oracle
  17. Is there any way to flush output from PL/SQL in Oracle?
  18. PLSQL Insert into with subquery and returning clause
  19. SELECT from table with Varying IN list in WHERE clause
  20. Does Oracle use short-circuit evaluation?
  21. Advice Using Pivot Table in Oracle
  22. ORACLE SQL:Get all integers between two numbers
  23. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  24. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  25. How do NULL values affect performance in a database search?
  26. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  27. “column not allowed here” error in INSERT statement
  28. Concat function is not working – invalid number of arguments
  29. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?
  30. Oracle IN vs Exists difference?

Leave a Comment