title: Use special character '%' to append the string in update statement
body: <p>I need to update a table where the table column is of <code>varchar2</code> datatype and need to update the value of columns with <code>'%'</code>.</p>
  
  <p>for example --</p>
  
  <pre><code>create table test (id number, name varchar2(20));
  
  insert into test values (1, 'smith');
  insert into test values (2, 'allen');
  </code></pre>
  
  <p>Now we need to update the values in NAME column to smith'%'</p>
  
  <p>So it should also include the single quotes in the string.</p>
  
  <p>I am able to update it to smith% but it should be smith'%'</p>
  
  <pre><code>update test
    set name = 'smith'||'''%'''
  where id = 1;
  </code></pre>
  
  <blockquote>
    <p>SQL Error: ORA-00911: invalid character</p>
  </blockquote>