Home » SQL & PL/SQL » SQL & PL/SQL » Auto generation Number (Oracle 10G)
Auto generation Number [message #578332] Wed, 27 February 2013 01:22 Go to next message
Messages: 38
Registered: March 2011
Location: chennai
Dear All,

Need to generate auto number as below
A00001 to A99999. After A99999 it should begin with B00001 and ends with B99999.
till Z99999 we need to generate.


Re: Auto generation Number [message #578333 is a reply to message #578332] Wed, 27 February 2013 01:26 Go to previous message
Michel Cadot
Messages: 63931
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a FAQ and posted not before than yesterday:

Please DO search before posting your questions.

Previous Topic: ref cursor
Next Topic: Handle exception Invalid identifier
Goto Forum:

Current Time: Thu Oct 27 08:30:13 CDT 2016

Total time taken to generate the page: 0.22066 seconds