Re: Curious Construct

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Fri, 24 Nov 2006 05:14:47 +0800
Message-ID: <1164316487.45660f470e744@mail.iinet.net.au>

Quoting Niall Litchfield <niall.litchfield_at_gmail.com>:

>
> 1. anyone else seen the NVL(select,select) construct?

yes. Peoplesoft is notorious for including that sort of complex construct. I've only used it once outside of that sphere and it was only one select.

> 2. what if anything did you do to rewrite.

From a remote memory we hinted it until it came back to a semblance of reason. Usually a plain vanilla /*+ RULE */ does the job, with a little bit of tweaking of table positions in FROMs if that's the case. This was before Peoplesoft was part of Oracle and we couldn't really make the appropriate noises in the appropriate places.

-- 
Cheers
Nuno Souto
from sunny Sydney
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 23 2006 - 15:14:47 CST