Padders, you did not read the post correctly or you might have missed some thing.

================================================
Is there any option to get Missing numbers between
two numbers with out using loop statement????
================================================

Sathy wanted a solution without a loop statement.

One can solve a problem in many ways.

I gave 2 solutions and Slimdave gave one solution.

What you are saying is post-mortem report.
First of all, we don't know why Sathy wants missing numbers. If it is for inserting rows in a table as using these missing numbers for PK, then it is a design fault. He has to go his drawing board, and redesign the appln. Or he just wants to know how to find out missing numbers for his academic knowledge, it is fine to use CUBE or PIPE or PL/SQL Table.

Tamil