Comparing Zeros in Oracle SQL

Question

Is there a better way to compare if two values ​​are equal, if they can be zeros other than the following?

a = b or (a is null and b is null) 

Answer 1

You can:

 a=b or coalesce(a,b) is null 

You can also use nvl , but this is an obsolete function, and coalesce is faster because it stops when the first non-zero

Answer 2

You can use DECODE(A,B,1) = 1

DECODE is irregular when handling NULL.

However, I think the intention is unclear and prefers vol7ron's answer. Clarity compared to the minimum character set!

Answer 3

You can wrap it with nvl and set it to some value not expected in your set:

 NVL(a,0) = NVL(b,0)