Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Auto incrementing key

Re: Auto incrementing key

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 11 Apr 2006 20:43:17 +0200
Message-ID: <e1gtai$2aq$2@news1.zwoll1.ov.home.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US