andrewst wrote:
>Originally posted by McStock
>
>
>>rownum is the pre-sort order of the rows -- rownum = 1 is not
>>always the
>>
>>
>>first row returned:
>>
>>
>><snip>
>>
>>
>
>OK, so in that scenario:
>
>
>select dname, deptno
>
>into ...
>
>from (select dname, deptno from dept order by dname desc)
>
>where rownum = 1;
>
>
>But I'll admit the implicit solution is starting to lose some of its
>charm here.
>
>--
>Posted via http://dbforums.com
>
>
I fail to understand why. Implicit cursors are better where they are
better. Not better where
whey aren't. Just like the debate over IN vs EXISTS. One must always
leverage the best
possible solution in a given situation. That means considering security,
scalability, performance
and maintainability. But not once would I consider the extra few seconds
it might take a
developer to write the code.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Nov 03 2003 - 10:44:30 CST
