How do I ignore ampersands in a SQL script running from SQL Plus?

by

This may work for you:

set define off

Otherwise the ampersand needs to be at the end of a string, 

'StackOverflow &' || ' you'

EDIT: I was click-happy when saving… This was referenced from a blog.

More Related Contents:

  1. When do I need to use a semicolon vs a slash in Oracle SQL?
  2. How do I spool to a CSV formatted file using SQLPLUS?
  3. Escaping ampersand character in SQL string
  4. How to get Oracle create table statement in SQL*Plus
  5. How to kill a running SELECT statement
  6. sqlplus statement from command line
  7. How to insert a string which contains an “&”
  8. How do I limit the number of rows returned by an Oracle query after ordering?
  9. LISTAGG in Oracle to return distinct values
  10. Using ‘case expression column’ in where clause
  11. Oracle SQL escape character (for a ‘&’)
  12. SQL Error: ORA-00933: SQL command not properly ended
  13. CASE vs. DECODE
  14. Convert a string date into datetime in Oracle
  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. How to replace specific values in a oracle database column?
  26. ORA-01861: literal does not match format string
  27. Query a Table’s Foreign Key relationships
  28. Backup SQL Schema Only?
  29. IN vs OR of Oracle, which faster?
  30. is there a PRODUCT function like there is a SUM function in Oracle SQL?

Leave a Comment