 |  |  |  |  |  |  |  |
Deletion of Autonumber
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I am doing a project using oracle10g XE and JSP.
Here i am using a table where data type of a field is autonumber.
It is working fine when i insert or update record. but it does not continue its sequence when i delete a record.
For example i have inserted 3 rows where 'id' is autonumber field then it will have 1,2,3 as its values. But if i delete the 3rd record then the next inserted value will be 5 ie, 1,2,3,5.. I want it to continue its sequence even if i delete any record.. What can i do to do that.?
Is there any solution for this.?
Here i am using a table where data type of a field is autonumber.
It is working fine when i insert or update record. but it does not continue its sequence when i delete a record.
For example i have inserted 3 rows where 'id' is autonumber field then it will have 1,2,3 as its values. But if i delete the 3rd record then the next inserted value will be 5 ie, 1,2,3,5.. I want it to continue its sequence even if i delete any record.. What can i do to do that.?
Is there any solution for this.?
•
•
Join Date: Dec 2004
Posts: 4,188
Reputation: 
Solved Threads: 482
This is correct procedure. Can you imagine how much time would by consumed in either searching for empty position or moving data up to fill empty position in database with millions of records?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
|
Other Threads in the Oracle Forum
- Previous Thread: Subtracting a negative value
- Next Thread: How to make query to retrieve first,last,next,Preivius data from databse
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Oracle Posts
- Today's Posts
- Unanswered Threads
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
