Hello,
I don't understand why I have invalid number error here. Based on this, both expressions should evaluate to a character data type
select NVL(
to_char(decode(1, 2, 4, to_char(4)||'%')),
decode(2, 2, to_char(3)||'%',
to_char(3)
)) from dual
Basically, this
to_char(decode(1, 2, 4, to_char(4)||'%'))
can be either number or character, and also the second argument of nvl,
decode(2, 2, to\_char(3)||'%',
to\_char(3)
)
can be either number or character data type, depending on data (I put above just sample numbers).
Thanks!