title: How to perform string concatenation in PL/SQL?
body: <p>I have a variable defined as</p>
  
  <pre><code>define dbs '&amp;1'
  </code></pre>
  
  <p>Suppose I pass <code>database1</code> as an argument. Then the statement is interpreted as</p>
  
  <pre><code>define dbs database1
  </code></pre>
  
  <p>I want to append single quotes around the string, ie I want it to be interpreted as</p>
  
  <pre><code>define dbs 'database1'
  </code></pre>
  
  <p>How should I do this?</p>