Re: Simple question ...

On Fri, 06 Aug 2004 23:25:15 +0200, Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl> wrote:

>On Fri, 6 Aug 2004 15:13:24 +0200, "Ernest Morariu"
><ernest_at_gesora.com> wrote:
>
>...
>>
>>SELECT myField INTO myVariable FROM myTable WHERE myCondition;
>>
>...
>
>You could alter this slightly:
>
>SELECT MAX(myField) INTO myVariable FROM myTable WHERE myCondition;
>
>In case of no records this will yield NULL
>In case of one record this will yield myField
>
>But note: the case of more than one record will now not error.
>
>Jaap.

It will also fetch all affected records and conduct an internal sort on them. A pretty inefficient solution.

--
Sybrand Bakker, Senior Oracle DBA