Generate Alphanumeric Sequence
Posted on 2013-06-25
I am creating a form application using APEX. It has 4 fields as follows.
The channel gives a list of values to be filled into form. Lets say it has 3 values (AGG, SUB, MOB). When AGG is selected, the code should be automatically filled with an alphanumeric sequence let say AGG001. When we are adding a new row in the form if again AGG is selected code should be AGG002 and so forth. Similarly if MOB is selected MOB001, MOB002 etc should be selected. Please let me know if this is possible to implement.
Also can alphanumeric Sequences be created in Oracle. If we can, do we have to create as many sequences as that of list of values in the in the channel or can we have just one sequence to generate different set of alphanumeric sequence..
Please let me know..I am new to APEX. Here is a sample form..
Channel Code Name Cntry
MOB MOB000001 abc us
AGG AGG000001 xyz us
MOB MOB000002 lmn us