I have a query using condition where the first result is a number and the second is a string.

Example:

```
Select Decode(Emp_Type,1,salary , 'The Employee has no salary') 
from Emp;

```

It gives me this error:

> 
> ORA-01722: invalid number
> 
> 
> 

When I use another statement using CASE:

```
Select case when  Emp_Type = 1 then salary else 'The Employee has no salary' End
from Emp;

```

it gives me this error:

> 
> ORA-00932: inconsistent datatypes : expected NUMBER got CHAR
> 
> 
> 

What is the solution?