To generate each rows with unique IDs (primary key) in ascending order
I am inserting values inside ADW in Oracle Apex through REST API parameters. I am able to get unique values but the order is getting random after inserting two rows. I have attached a screenshot of the customer table. Sequence of the rows are (2)->(1)->(4)
After deleting 3rd row I am getting ID as 4. It should have been 3 and the order should be (1)->(2)->(3). How to achieve this?