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
break char into segments
- Fist of the eskimo
- Canadian Ambassador
- Posts:3866
- Joined:Tue Nov 27, 2007 1:11 pm
- Location:Edmonton, AB
- Contact:
Who is online
Users browsing this forum: No registered users and 2 guests