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.
Need help with your code? Post it here and we'll try our best to help.
2 posts •Page 1 of 1
- Fist of the eskimo
- Canadian Ambassador
- Joined:Tue Nov 27, 2007 1:11 pm
- Location:Edmonton, AB
Who is online
Users browsing this forum: No registered users and 1 guest