Increment Character Value By 1
<p>I have the following data in a column of a table which is not a primary key</p>

<pre><code>0000

0001

0002
</code></pre>

<p>I would like to increment the value to increment by 1, which means result should be </p>

<pre><code>0003
</code></pre>

<p>using a sql statement.</p>

<p>How can I do this</p>

<p>Column data type is <code>varchar2</code></p>

<p>Edit 1</p>

<pre><code>SELECT col + 1
  FROM tab2 
  where prod_id = 'A267'
</code></pre>

<p>The result is 3, ideally it should be 0003</p>