break char into segments
Posted: Thu Apr 17, 2008 2:28 am
gents,
Anyone have some experience with SQL and triggers? Attempt:
I have a table, for instance tutor, that has a TutorID that I want to auto increment, however, it is a char string, in this case, t001, t002, etc. If it were simply a number, it wouldn't be an issue. So, what I want to do....
I want to make a trigger or stored function that breaks that char into 2 segments: the character and the numbers, then increment the numeric part, and then piece the two back together.
Any ideas? Working in Oracle DB.
-Kama
Anyone have some experience with SQL and triggers? Attempt:
I have a table, for instance tutor, that has a TutorID that I want to auto increment, however, it is a char string, in this case, t001, t002, etc. If it were simply a number, it wouldn't be an issue. So, what I want to do....
I want to make a trigger or stored function that breaks that char into 2 segments: the character and the numbers, then increment the numeric part, and then piece the two back together.
Any ideas? Working in Oracle DB.
-Kama