Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Add missing number in a table column using sequence

user2081225Feb 13 2024

I have a table with one column (e.g. Order ID) and I already have 10 rows in it. Each row have a random number in Order ID (like 1, 4, 6, 9, 34, 45 etc). Now I want to use brand new Oracle Sequence to add numbers in that column. How I can add missing number in Order ID using Sequence (like 2, 3, 5, 7, 8 etc). Any way to resolve it using Oracle Sequence?

Comments
Post Details
Added on Feb 13 2024
10 comments
216 views