Hello All,
I am trying to run the following query:
select budget,
sum(to_number(beg_bal,'999,999,999.99')),
sum(to_number(month1,'999,999,999.99')),
sum(to_number(month2,'999,999,999.99')),
sum(to_number(month3,'999,999,999.99')),
sum(to_number(month4,'999,999,999.99')),
sum(to_number(month5,'999,999,999.99')),
sum(to_number(month6,'999,999,999.99')),
sum(to_number(month7,'999,999,999.99')),
sum(to_number(month8,'999,999,999.99')),
sum(to_number(month9,'999,999,999.99')),
sum(to_number(month10,'999,999,999.99')),
sum(to_number(month11,'999,999,999.99')),
sum(to_number(month12,'999,999,999.99')),
sum(to_number(end_bal,'999,999,999.99'))
from ct_mods.gl_actuals_1990_99
group by budget
order by budget
I am getting the ORA-01722: invalid number. The error seems to be in the "end_bal" column( in the above query if I comment out the end_bal statement, it works fine).
How do I find that one problem record in the "end_bal" column? ( I have close to about a million records in that table....I still need to load close to another half a million rows into it)
Thanks,
Chiru