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

Report message to a moderator

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: 54236
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 19:24:02 CDT 2013

Total time taken to generate the page: 0.71066 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.