title: Add incrementing value together with other values into a column in Oracle database
body: <p>I have a column Processed in a table Employee. Processed value forms a string: "timestamp" + "employeeID" + an incrementing/sequencing value (ie. 1, 2, 3...). </p>
  
  <p>The goal is:</p>
  
  <ol>
  <li>The string value would be unique(incrementing value)</li>
  <li>I can roughly see the time when it was processed(timestamp)</li>
  <li>Which employee it is about(employeeID)</li>
  </ol>
  
  <p>My current solution has a table made only for the incrementing value part. There is one column, that gets queried for the value, the value is then added to the end of the Processed string. After this, the incrementing table value is updated with the incremented value.
  It is created with Oracles sequence and trigger functions: see <a href="https://chartio.com/resources/tutorials/how-to-define-an-auto-increment-primary-key-in-oracle/" rel="nofollow noreferrer">https://chartio.com/resources/tutorials/how-to-define-an-auto-increment-primary-key-in-oracle/</a></p>
  
  <p><strong>How ever, I don't think this solutions is optimal and I was wondering if this could be done without the additional table made just for incrementing a single value?</strong></p>
  
  <p>I am using Oracle Database 19c.</p>