Home » SQL & PL/SQL » SQL & PL/SQL » AUTO NUMBERING WITH ALPHANUMERIC
AUTO NUMBERING WITH ALPHANUMERIC [message #10450] Thu, 22 January 2004 20:49 Go to next message
sandeep
Messages: 110
Registered: October 2000
Senior Member
How can we gentrate autonumbering.i tried with sequneces
how can we include alphanumeric fileds with
this sequence just like
abc100
abc101
sandeep
Re: AUTO NUMBERING WITH ALPHANUMERIC [message #10452 is a reply to message #10450] Thu, 22 January 2004 23:09 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You can't, but you could add the alphanumeric part in the trigger code to populate the field:

:NEW.your_column := 'ABC'||your_sequence.nextval;

MHE
Re: AUTO NUMBERING WITH ALPHANUMERIC [message #10457 is a reply to message #10450] Fri, 23 January 2004 08:15 Go to previous message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
If you want to generate alphanumeric characters sequentially, you could think of it as generating integers as normal then converting them to base 36. There is an example here.
Previous Topic: Comptability between client and server versions
Next Topic: pl/sql error
Goto Forum:
  


Current Time: Fri Mar 29 08:35:54 CDT 2024