RE: to_number question

From: <Stephen.Lee_at_DTAG.Com>
Date: Wed, 14 Jul 2004 20:27:03 -0500
Message-ID: <D6339830FC73944E889CC3CEADDB205B07909518@bu-dtagpo1.tracs.com>

And observe some more ....

select distinct nbr_cc_fop_name, (X - Y) xxx, (X+Y) yyy

from (
select nbr_cc_fop_name, to_number(trim(nbr_cc_no_high)) X , to_number(trim(nbr_cc_no_low)) Y

from nbr_cc
where nbr_cc_fop_name in ('AX','MC','VI','DS') )

NBR_CC               XXX                YYY


------ ----------------- ------------------

AX         9999999999999    689999999999999
AX         9999999999999    749999999999999
DS          999999999999  12022999999999999
MC       407999999999999  11591999999999999
MC       590999999999999  10590999999999999
VI          999999999999      8999999999999
VI       999999999999999   8999999999999999



----------------------------------------------------------------

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 Wed Jul 14 2004 - 20:23:53 CDT