Home » SQL & PL/SQL » SQL & PL/SQL » Autogenerated ID (Oracle 10g)
Autogenerated ID [message #310775] Wed, 02 April 2008 06:47 Go to next message
sitangshu
Messages: 2
Registered: April 2008
Location: New Delhi
Junior Member

The SEQUENCE keyword of oracle can only generate a limited number of auto generated numbers.
Is there any other process by which oracle can generate millions unique auto generated numbers.
It is required because i want to use it for maintaining login details of users.
Re: Autogenerated ID [message #310777 is a reply to message #310775] Wed, 02 April 2008 07:11 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
The SEQUENCE keyword of oracle can only generate a limited number of auto generated numbers

Limited? 2*9999999999999999999999999999+1.
I don't think you can ever exhaust all numbers.

Regards
Michel
Previous Topic: ORA-00904: invalid identifier error with Foreign Keys
Next Topic: SQL%ROWCOUNT
Goto Forum:
  


Current Time: Tue Dec 06 12:23:44 CST 2016

Total time taken to generate the page: 0.21565 seconds