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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

query to fetch single record

mist123Feb 5 2021

Hi All,
Database: 11.2
I have query below and i need the record where order_no is NULL and don't populate where order_no is NULL if check_num is same.

select NULL order_no, '202020'check_num from dual
union all
select '101010' order_no, '202020'check_num from dual
union all
select NULL order_no, '404040'check_num from dual --> i need this record only.

This post has been answered by mathguy on Feb 5 2021

Jump to Answer

Added on Feb 5 2021

3 comments

894 views