RE: SQL has me confused.

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 16 Oct 2013 10:30:44 -0400
Message-ID: <05e901ceca7c$4dde41d0$e99ac570$_at_rsiz.com>

You wrote: " The solution has been to change the query by adding the appropriate alias as shown below:"

Yes. Far better to be explicit in all references. Last time I measured (and if memory serves Steve Adams nailed this down chapter and verse) it also saves time in parsing (though the advantage may be small it tended to increase with the size of the dictionary).

And of course being explicit makes things easier on the human reader.

The things that previously worked with an ambiguous column reference were all bugs of the most insidious kind: For a while they work (possibly even getting correct results) and then they break when the complier is fixed.

Now, if only someone wrote a language specification similar to SQL that was orthogonal and relationally complete. Hmm. Perhaps a retirement project...

mwf

<snip>

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

Received on Wed Oct 16 2013 - 16:30:44 CEST