lowest free number

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


------------------------------------------------------------------------------