Is there any way to set 'varcar' in number type?

When I write,

SELECT last_name,NVL(commission_pct,0)
FROM Hr.employees;

It works fine. When Commission percentage is null then it set to 0.

But i want to set ‘NO COMMISSION’ instead of 0.

>Solution :

If you return the commision value as a string, yes.

select last_name, nvl(to_char(commission_pct),'NO COMMISSION')
from hr.employees