You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

To generate each rows with unique IDs (primary key) in ascending order

edited Feb 1, 2021 6:07AM in Autonomous Database 4 comments

Content

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!