I have the following query in a PL/SQL block:
select nvl(include_in_dif, 1)
where pcc in (select nvl(pcc, 'NONE')
where bomtype = 'MRP'
and partnum = 'DIFREPORT-001');
The Sub query returns no rows so the whole query returns nothing. I would like m_include_in_dif to default to '1' if no rows are returned. The above query does not do this of course.
Can I do this in one query. Any ideas ... ?