Re[2]: to_number question

  • From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
  • To: Wolfgang Breitling <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 Jul 2004 13:52:16 -0400

Thursday, July 15, 2004, 12:50:58 PM, Wolfgang Breitling 
(breitliw@xxxxxxxxxxxxx) 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 * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit, 
or send email to Oracle-article-request@xxxxxxxxxxx and 
include the word "subscribe" in either the subject or body.

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: