> -----Original Message----- > One of the ways to make sure that a subquery is evaluated on > its own and not > flattened (unnested) into the whole query is to use the > rownum pseudocolumn: I got around to trying this, and it works too. What a fine list group this is. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------