Oracle SQL - return some default value if query don't return results

Question

When run below query results is empty. Is it possible use some eg. NVL for return some value eg. -1

Select ename from emp where empno = 1

Gordon Linoff · Accepted Answer · 2021-08-03 12:20:48Z

2

If you are expecting one row, you can use aggregation:

Select coalesce(max(ename), '-1')
from emp
where empno = 1;

This always returns one row, even when there is no match.

answered Aug 3, 2021 at 12:20

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1