Decode x NVL

[Trevisolli]

Personnel, I saw in a code, the following stretch:

Select all

 
  AND DECODE(NRO_RG, NULL, NRO_CPF, NRO_RG); 

Sorry for ignorance, but even for performance reasons, it would not be better below:

Select all

 
  AND NVL(NRO_RG,NRO_CPF); 

If I am wrong, please correct me in this topic.

Hugs,

: -O

[dr_gori]

Do not worry, you're very well.
There is no reason to make such a decode. :-O

[Trevisolli]

Vlw Brother.
Blaza.