Re[2]: to_number question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Thu, 15 Jul 2004 13:52:16 -0400
Message-ID: <113999316991.20040715135216@gennick.com>

Thursday, July 15, 2004, 12:50:58 PM, Wolfgang Breitling (breitliw_at_centrexcc.com) wrote:

WB> Sorry Stephen (Lee) and Jonathan (Gennick), if you thought you stumbled on 
WB> something new I have to disappoint you. Others have made the same mistake 
WB> before. Take solace in the fact that you are not going to be the last ones 
WB> either.

Astounding. It's also astounding I've never run into this issue before. It's not like I never write subqueries.

I think I'm going to write an article about this. More people need to understand this subtle issue of how subqueries (don't) work. I still disagree with the approach that you and Tom (Kyte) describe, but that doesn't really matter a whole lot now, because the behavior "is what it is", whether I like it or not.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jul 15 2004 - 12:49:06 CDT