title: How to check any missing number from a series of numbers?
body: <p>I am doing a project creating an admission system for a college; the technologies are Java and Oracle. </p>
  
  <p>In one of the tables, pre-generated serial numbers are stored. Later, against those serial numbers, the applicant's form data will be entered. My requirement is that when the entry process is completed I will have to generate a Lot wise report. If during feeding pre-generated serial numbers any sequence numbers went missing. </p>
  
  <p>For example, say in a table, the sequence numbers are 7001, 7002, 7004, 7005, 7006, 7010.
  From the above series it is clear that from 7001 to 7010 the numbers missing are 7003, 7007, 7008 and 7009</p>
  
  <p>Is there any DBMS function available in Oracle to find out these numbers or if any stored procedure may fulfill my purpose then please suggest an algorithm. </p>
  
  <p>I can find some techniques in Java but for speed I want to find the solution in Oracle.</p>