Pergunta de entrevista da empresa Roadmap IT Solutions
nvl and nvl2 difference b/w?
Resposta da entrevista
Sigiloso
28 de mar. de 2025
Nvl(arg1,arg2) nvl is used for converting null values. In nvl if argument 1 is null then it returns argument 2 but argument 1 is not null it returns itself. In nvl2 (arg1,arg2,arg3) in nvl2 it converts any number into according to given number with null also .