Way to keep null values in the output? (Oracle)

Question

So I'm working with this data base and I get the following output

I want to make sure that only data with 5 is seen even if there is data with an empty "null" space.

using

where 5 = all(l1,l2,l3)

almost works but it gets rid of the ones with empty spaces. Is there a way to keep the null spaces?

Littlefoot · Accepted Answer · 2018-07-23 16:53:40Z

2

Maybe

where 5 = all (nvl(l1, 5),
               nvl(l2, 5),
               nvl(l3, 5)
              )

answered Jul 23, 2018 at 16:53

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Do, or do not - there is no "maybe".