Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How To Trap No Rows Returned From Select Statement

Re: How To Trap No Rows Returned From Select Statement

From: Tony <andrewst_at_onetel.net.uk>
Date: 7 Jul 2004 09:02:24 -0700
Message-ID: <c0e3f26e.0407070802.3dffe2e2@posting.google.com>


"Chris \( Val \)" <chrisval_at_bigpond.com.au> wrote in message news:<2l1n0nF7m4jiU1_at_uni-berlin.de>...
> "Tony" <andrewst_at_onetel.net.uk> wrote in message
> news:c0e3f26e.0407060409.75c16a93_at_posting.google.com...
> | (I took the liberty of adding a useful ORDER BY clause to the query).
>
> I must admit that I didn't even think about it, presumably
> because I thought that the lines would be ordered by default
> anyway.
>
> Is this not the case ?

Not in general no. Quite likely you will find that it works without the ORDER BY, since it tends to "come out as it went in". But this is NOT guaranteed and you should never rely on it in a real program. Received on Wed Jul 07 2004 - 11:02:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US