This code snippet is an extension of my earlier code snip How to select the records from a table following a pattern.
There I used ROWNUM to find the even/odd records from the emp table. Current
code snip achieves the same functionality even without the use of ROWNUM. This
method proves useful when it is asked to avoid the use of ROWNUM.