How to avoid variable substitution in Oracle SQL Developer

by

Call this before the query:

set define off;

Alternatively, hacky:

update t set country = 'Trinidad and Tobago' where country = 'trinidad &' || ' tobago';

From Tuning SQL*Plus:

SET DEFINE OFF disables the parsing of commands to replace
substitution variables with their values.

More Related Contents:

  1. How can I set a custom date time format in Oracle SQL Developer?
  2. Printing the value of a variable in SQL Developer
  3. How to export query result to csv in Oracle SQL Developer?
  4. NLS_NUMERIC_CHARACTERS setting for decimal
  5. How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
  6. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  7. Spool Command: Do not output SQL statement to file
  8. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  9. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  10. How can I find which tables reference a given table in Oracle SQL Developer?
  11. Oracle Equivalent to MySQL INSERT IGNORE?
  12. null vs empty string in Oracle [duplicate]
  13. Convert comma separated string to array in PL/SQL
  14. UTL_FILE.FOPEN() procedure not accepting path for directory?
  15. Oracle stored procedure with parameters for IN clause
  16. Split function in oracle to comma separated values with automatic sequence
  17. ORA-06508: PL/SQL: could not find program unit being called
  18. How to handle to_date exceptions in a SELECT statment to ignore those rows?
  19. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  20. Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)
  21. HIbernate issue with Oracle Trigger for generating id from a sequence
  22. Using Alias in query resulting in “command not properly ended”
  23. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  24. How to insert a column in a specific position in oracle without dropping and recreating the table?
  25. Is it possible to kill a single query in oracle without killing the session?
  26. Get the LENGTH of a LONG RAW
  27. MySQL equivalent of ORACLES rank()
  28. Reading clob line by line with pl\sql
  29. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  30. Find out the history of SQL queries

Leave a Comment