Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Auto incrementing key
chanakam2000_at_gmail.com wrote:
> Thank you for your advice.
> But my problem is i want to have number not only to student but also
> for books and courses.
>
> So i want to have that prefix
>
> otherwise there will be same number for book, student ,and courses
>
> I mean 00001 student & 00001book and 00001 course.
> Thats why i tried to add the prefix.
>
> Do you have an idea to overcome from this without much complex work?
>
Use different sequences for books, students, apartments, classrooms,
courses, pupils, professors, etc, etc, etc.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Tue Apr 11 2006 - 13:43:17 CDT