Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Problem
Hi, Mike.
If you can't use the NO_DATA_FOUND exception, then I would suggest doing one of the following...
Hope this helps,
-Jeff Guttadauro
On Thu, 12 Aug 1999 09:11:03 -0400, "Mike Heisz" <mheisz_at_rim.net> wrote:
>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:42:42 CDT