Oracle Database Discussions

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!

Question in Union with Null column value

TinaJun 5 2018 — edited Jun 5 2018

Gurus,

Does this query give distinct row every time?

I was skeptic about null value and was hoping I would get distinct rows.

Can I rely on null for distinctness in this case?

select 1,2,3,null from dual

union

select 1,2,3,null from dual

This post has been answered by SeánMacGC on Jun 5 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2018

Added on Jun 5 2018

#general-database-discussions

2 comments

1,442 views