Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

I have non numeric values in my number column. How it is possible.

905179Mar 1 2016 — edited Mar 1 2016

Hi ,

We have table DV_OM_AR_DETAIL that has a column ORG_ID that is a NUMBER .

But today I got a strange behaviour.

if I run the statement

select to_number(ORG_ID) from DV_OM_AR_DETAIL ;

This gives me error as ''ORA-01722: invalid number"


But my question is how can non numeric value can enter into my NUMBER datatype column?


Thanks

Nawneet

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 29 2016
Added on Mar 1 2016
19 comments
6,966 views