RE: owb and NVL

From: TJ Kiernan <tkiernan_at_pti-nps.com>
Date: Tue, 29 Nov 2011 12:58:37 -0600
Message-ID: <3DC440E2338A24439D527C2E64E1ECBC04B580_at_deeds.pti-nps.com>

Looking at both my simple and convoluted mappings, I'm not seeing NVL() functions except where I wrote them in the GUI, so either this is some version-specific muddiness, or there's an ETL developer who gets paid per line of code.

For reference, I'm on 11.1 on Windows 2008 x64.

HTH,
T. J.
 

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Tuesday, November 29, 2011 5:39 AM To: ORACLE-L
Subject: owb and NVL

I'm looking at an OWB generated statement (and so my head is exploding) which is full of subqueries like the following. SELECT NVL(T1.KEY_VALUE, NULL)... I sure am puzzled as to why the tool would generate this and not

SELECT T1.KEY_VALUE... other than to further muddy the waters.
--

Niall Litchfield
Oracle DBA
http://www.orawin.info

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 29 2011 - 12:58:37 CST