to_number question 2004-07-15 - By Wolfgang Breitling
Quoting Jonathan Gennick <jonathan@(protected) >:
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
