Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How To Trap No Rows Returned From Select Statement
"Tony" <andrewst_at_onetel.net.uk> wrote in message
news:c0e3f26e.0407070802.3dffe2e2_at_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.
Thanks for the information Tony and Ed, I will keep it in mind for any future code.
Cheers.
Chris Val
Received on Thu Jul 08 2004 - 03:44:12 CDT