Chaps, it has been a long day and I have been chasing a bug in ORM generated
SQL all afternoon. I demo it minimally below using some contrived code.
Do I just need some sleep? 3, really?
Mike
Woodward Informatics Ltd
SQL>
SQL>
SQL> desc foo
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
SQL> select * from foo;
ID
----------
1
2
3
SQL> select f1.id from foo f1 where f1.id > all (select f0.id from foo f0 where
f0.id > f1.id);
ID
----------
3
SQL>
SQL>
SQL>
--
//www.freelists.org/webpage/oracle-l