Re: lowest free number

From: David P <davidp3_at_soho.ios.com>
Date: 1996/06/25
Message-ID: <31cf694f.774717_at_198.4.75.200>#1/1


On 24 Jun 1996 13:31:14 GMT, vgoel_at_pts.mot.com (Vikram Goel (Cntr)) wrote:

>Michael,
>
>Try select min(<col_name> from <table_name>;
>
>
>Hope this helps,
>
>--
>Vikram Goel
>Sr. Oracle DBA - Consultant
>Aerotek Inc. My email: vgoel_at_emi.net
>
>Motorola Info: Motorola email: vgoel_at_pts.mot.com
>Mail Stop 39, Room S1014
>1500 Gateway Blvd,
>Boynton Beach, FL 33426
>
>
>In article <31CD92EA.3DEE_at_fhzinfo.fh-bielefeld.de>, Michael Daehling <daehling_at_fhzinfo.fh-bielefeld.de> writes:
>>Hi,
>>
>>I want to get the lowest free number of a column. The column is a continuous
>>number and the primary key of the table. I want to recycle the old numbers
>>after delete.
>>I think a PL/SQL-function can do this - or is there a simple solution?
>>
>>
>>Thanks in advance
>>
>>Michael Daehling
>>--
>>------------------------------------------------------------------------------
>>Michael Daehling
>>FH-Bielefeld Email: daehling_at_fhzinfo.fh-bielefeld.de
>>Willhelm-Bertelsmann-Str.10 Tel.: +49 521 106 2334
>>33602 Bielefeld
>>------------------------------------------------------------------------------
>
>
>
Just could not stand it....

?????????????????????????????????????????????????????????????????????????????????????
Dave Received on Tue Jun 25 1996 - 00:00:00 CEST

Original text of this message