owb and NVL

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 29 Nov 2011 11:39:07 +0000
Message-ID: <CABe10sYBO=d5rBNZ=Mv8=KZHpgKfHJDXOZdBvr+T4JQ170uJfA_at_mail.gmail.com>

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.freelists.org/webpage/oracle-l Received on Tue Nov 29 2011 - 05:39:07 CST

Original text of this message