Substitution Variable

In Toad Or Oracle SQL*Plus, the & character is treated as the beginning of a substitution variable. This can cause unexpected behavior when your script contains & for other reasons—like inside a string literal. For example, the following SQL statement will trigger a prompt: To avoid this, you can disable substitution by running: This tells … Read more