title: Oracle - Insert New Row with Auto Incremental ID
body: <p>I have a workqueue table that has a workid column. The workID column has values that increment automatically. Is there a way I can run a query in the backend to insert a new row and have the workID column increment automatically?<br>
  When I try to insert a null, it throws error ORA01400 - Cannot insert null into workid.</p>
  
  <pre><code>insert into WORKQUEUE  (facilitycode,workaction,description) values ('J', 'II',    'TESTVALUES')
  </code></pre>
  
  <p>What I have tried so far - I tried to look at the table details and didn't see any auto-increment. The table script is as follow</p>
  
  <pre><code>"WORKID" NUMBER NOT NULL ENABLE,
  </code></pre>
  
  <p>Database: Oracle 10g</p>
  
  <p>Screenshot of some existing data.
  <img src="https://i.stack.imgur.com/dhhDe.png" alt="enter image description here"></p>
  
  <hr>
  
  <p><strong>ANSWER:</strong></p>
  
  <p>I have to thank each and everyone for the help. Today was a great learning experience and without your support, I couldn't have done. Bottom line is, I was trying to insert a row into a table that already has sequences and triggers. All I had to do was find the right sequence, for my question, and call that sequence into my query.</p>
  
  <p>The links you all provided me helped me look these sequences up and find the one that is for this workid column. Thanks to you all, I gave everyone a thumbs up, I am able to tackle another dragon today and help patient care take a step forward!"</p>