PLSQL - I need to calculate the number of consecutive shelf slots
Posted on 2007-08-01
I have a table of ALL shelf locations and a table of used shelf locations.
To see the ones that are available I have the following:
where LOC_CD NOT IN (select LOC_CD from COPY_SLOT_XREF)
But, now I want to show that list as the starting Location and the number of consecutive shelf slots next to it as so:
I need to find all the locations that have X consecutive shelf slots
Ex: Search on 2
How do I go about this?