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 - only in where clause

745509Feb 21 2012 — edited Feb 21 2012

I am getting ORA-01722: invalid number when using to_number in where clause:

select to_number(txt_field) from tbl where 100>=to_number(txt_field);

I am not getting it without where clause (300 rows returned):

select to_number(txt_field) from tbl;

Any logical explanation?

Edited by: totalnewby on Feb 21, 2012 4:54 AM

This post has been answered by Solomon Yakobson on Feb 21 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2012

Added on Feb 21 2012

8 comments

3,364 views