/other/old_site_member_blogs/bentley_employees/b/keithbertrams_blog/posts/finding-gaps-of-numbers-within-an-oracle-tableToday I needed to find a gap within a series of numbers located in a table. So for instance I have a table with a series of mslink values: MSLINK 1 2 3 5 In the above table, I want to find the numberen-USTelligent Community 12https://communities.bentley.com/other/old_site_member_blogs/bentley_employees/b/keithbertrams_blog/posts/finding-gaps-of-numbers-within-an-oracle-tableTue, 25 Aug 2009 23:13:43 GMT6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:c0f08de2-16c9-4754-8daf-6b502075c1e9mccalla0<p>What happens if the first record is missing MSLINK = 1; &nbsp;I don't think your query will pick it up since it is starting with mslink(2) + 1?</p> <p>Also I don't think it will work if the gap is more than 1??</p> <img src="https://communities.bentley.com/aggbug?PostID=29683&AppID=29879&AppType=Weblog&ContentType=0" width="1" height="1">