I would expect this:LBound UBound 1 2 5 5 7 8 12 12
I'm more from a SQL Server background... could I create a temporary table, fill it with the correct values and then return the result from a SPROC or function? D. On Sat, Sep 5, 2009 at 10:47 AM, Michael Moore <michaeljmo...@gmail.com>wrote: > This would probably best be solved procedurally. If you can come up with a > query that does it, it will probably be very ugly. Also, what result would > you expect in this case: > > 1 > 2 > 5 > 7 > 8 > 12 > > ?? > > Mike > > > On Sat, Sep 5, 2009 at 6:49 AM, Dave Hart <david.john.h...@gmail.com>wrote: > >> >> Hi, >> I have a table which includes data like this: >> >> SEQ >> 1 >> 2 >> 3 >> 4 >> 8 >> 9 >> 10 >> 11 >> 12 >> 13 >> 20 >> 21 >> 22 >> 23 >> 24 >> >> I want to be able to write a query that displays the upper and lower >> bounds of each range: >> LBound UBound >> 1 4 >> 8 13 >> 20 24 >> >> I've found plenty of queries that find the start and end of the gaps >> but none that display the start and end of the ranges. >> >> Any help is appreciated. >> >> Thanks, >> Dave >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
