One way would be to use WITH clause and make Oracle instantiating temporary tables that are then joined. On 5/15/07, Norman Dunbar <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I've been told by Oracle trainers that joining a V$ view to an physical table or other dictionary tyope objkect is fraught with danger because
-- Best regards, Alex Gorbachev http://www.oracloid.com -- //www.freelists.org/webpage/oracle-l