SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete one row from sequence

562167Feb 16 2007 — edited Feb 27 2007

Hi,
i have created one table and using sequence for automatically generating id.
i have successfully entered 5 rows....
my problem is when i delete 3rd row, the order is changed like 1,2,4,5 but
i want to get the data order like 1,2,3,4.
Is it possible....plz help me...i am novice to PL/SQL

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2007

Added on Feb 16 2007

20 comments

2,031 views