Re: lowest free number
Date: 1996/06/24
Message-ID: <4qm5b2$odu_at_lserv1.paging.mot.com>#1/1
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:
Received on Mon Jun 24 1996 - 00:00:00 CEST
>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
>------------------------------------------------------------------------------