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!

Ignore not numbers values

Saad NayefJul 19 2011 — edited Jul 19 2011

Hi,
I have a column containing a number stored as text, and I want to do some calculation on that column. So I'm using TO_NUMBER function, but the problem that some values are not really numbers like '4A' so I want to bypass or ignore the calculations on those values.
Can I do this in SQL without PL/SQL?

Saad,

This post has been answered by Saubhik on Jul 19 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2011

Added on Jul 19 2011

3 comments

189 views