Re: Trigger error

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