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: 62232
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: Mon Nov 30 18:53:59 CST 2015

Total time taken to generate the page: 0.08829 seconds