select 10 from dual
| 10 | 10 |
|---|
select 10 from dual where 1=5
no data found
Don't forget to put your select statement between brackets ()
select nvl(select 10 from dual where 1=5,0) from dual ORA-00936: missing expressionMore Details: https://docs.oracle.com/error-help/db/ora-00936
select nvl((select 10 from dual where 1=5),0) AS RESULT from dual | NVL((SELECT10FROMDUALWHERE1=5),0) | 0 |
|---|