Re: Re[2]: to_number question

Quoting Jonathan Gennick <jonathan_at_gennick.com>:

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

It should not be too astounding. If you design your system properly and use the correct column types for the data ( number types for numbers, date types for dates ) then you do not run into this issue.

Which is also why I am not in favour of Dan (Tow)'s suggestion that the database engine work overtime to work around those cases of poor design. There are other, better ways of dealing with them. You need to be aware of the issues and the solutions, however.

-- 
Regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

----------------------------------------------------------------
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
-----------------------------------------------------------------