Page 1 of 1

break char into segments

Posted: Thu Apr 17, 2008 2:28 am
by Kamasabi
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

Posted: Thu Apr 17, 2008 7:07 pm
by Fist of the eskimo
I remember seeing an article on this in one of the forums, but I can't remember where. Just search for lludium-Q36 and it should be the first or second link in google.