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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to get available IDs?

Re: How to get available IDs?

From: Thorsten Kettner <thorsten_kettner_at_my-deja.com>
Date: Thu, 18 Jan 2001 12:50:41 GMT
Message-ID: <946oqv$32$1@nnrp1.deja.com>

Each one in it's own row.



In article <3a65ba6a.683608297_at_news.alt.net>,   SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) wrote:
> On Wed, 17 Jan 2001 11:20:49 GMT, Thorsten Kettner
> <thorsten_kettner_at_my-deja.com> wrote:
>
> >Hi Brian. Available means not yet used. This is why I subtract the
 set
> >of all emp_no that I can find in table emp from the set of all
> >available numbers (0 to 999). If I have three emploees with emp_no
 1, 2
> >and 4 I want to get the numbers 0,3,5,6,7 and so on to 999. Do you
 have
> >a better solution than the way I have used?
>
> How do you want the numbers returned? As a string? Each one in it's
> own row?
>
> Brian
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 18 2001 - 06:50:41 CST

Original text of this message

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