This SQL gives an ORA-12704 and any suggestions on how to fix

Question

select 
CASE when length(attr2) > 0
        then attr2
        ELSE '-'
        END AS attr2
from vdata

desc vdata

attr2 nvarchar(30)

What is the best way to fix this?

could you please edit your question with expected output, and mark off your code so it is readable? — David Faber, Jan 27 '15 at 15:13

score 0 · Accepted Answer · answered Jan 27 '15 at 15:16

0

select coalesce(attr2, to_nchar('-')) from vdata

answered Jan 27 '15 at 15:16

1 Answers1