SQL Problem

From: Mike Heisz <mheisz_at_rim.net>
Date: Thu, 12 Aug 1999 09:11:03 -0400
Message-ID: <newscache$hmscgf$3gj$1@njord.rim.net>

I am trying to write a query to return 1 value. Sometimes there is no value and the query returns no data. i.e select a
from b
where
...... (here the conditions ensure that 1 or 0 rows are returned by the query)

I need to supply a defeault value to be used when there are 0 rows returned. Is this possble and if so how do you do it?

A couple of notes: This is part of a PL/SQL procedure but I can't use the NO_DATA_FOUND exception handler because I am dealing with files and this is used there.

Thanks,

Mike Received on Thu Aug 12 1999 - 08:11:03 CDT