Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql query to return odd and even numbers in a single query without using rownum/rowid

JSMQApr 5 2019 — edited Apr 6 2019

Hi - I have a scenario where i need to return odd and even numbers in a single sql query(env -Oracle 11.2.01) without using rownum/rowid.

Comments
Post Details
Added on Apr 5 2019
7 comments
11,321 views