This tip will help you understand how to apply the mod function and use it to obtain even and odd records from columns in Oracle.

Source