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
ORA_KRISH
Messages: 38
Registered: March 2011
Location: chennai
Member
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.

Regards

Krish
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: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a FAQ and posted not before than yesterday:
http://www.orafaq.com/forum/t/186416/102589/

Please DO search before posting your questions.

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


Current Time: Wed Oct 01 14:31:51 CDT 2014

Total time taken to generate the page: 0.08896 seconds