SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01722: Invalid Number

627509Feb 4 2009 — edited Feb 4 2009

Hi all
I am using following query to get sum of records.
I have around 35 Laksh records.

SELECT SUM(NVL(WORK_SPACE,0)) FROM TQDB_LEARNER_RESPONSE

I am getting following error,how to solve it.

ORA-01722: Invalid Number

Any body help me,it is very very urgent.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2009

Added on Feb 4 2009

9 comments

5,733 views