Hello
I was hoping someone could advise on how I can get from an Oracle sequence starting at 1 have a select that returns something like AA-01, AA-02...Once I get to 99, select should return AB-01, then AB-02... Not sure if this is clear for everyone??
Create SEQUENCE seq start with 1.
SELECT (xxx || seq) FROM dual return AA-01
SELECT (xxx || seq next val) FROM dual return AA-02
SELECT (xxx || seq next val) FROM dual return AA-03
SELECT (xxx || seq next val) FROM dual return AA-04
...
SELECT (xxx || seq next val) FROM dual return AA-99
SELECT (xxx || seq next val) FROM dual return AB-01
Any suggestion?
Regards,