title: auto incrementation in oracle APEX
body: <p>I have a following table Asset(assetID, assetType) where assetID is the primary key of the table.</p>
  
  <p>In oracle Apex, I want the users to be able to create a new instance of asset. But so far, it seems that I cannot do auto-increment for assetID instead of letting users type it manually every time.</p>
  
  <p>For example, currently if you want to create an asset, I need user's input of assetID and assetType and if there is an assetID that already exists, it does not create a same instance but tells the user that assetID already exists. </p>
  
  <p>I want to change this to auto-increment so the assetID is not all over the place. How do I do this?</p>