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!

Finding Non-Numeric Values in a colum

kamranpathanFeb 1 2008 — edited Feb 5 2008

Is there any function thru which I can find any nonnumeric value in 1st 7 characters of a column.Beware this column is a Varchar2 column and mostly it has numeric values in its 1st 7 characters but mistakenly user enters a character value there. So how can I find these non-numeric values???

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2008

Added on Feb 1 2008

29 comments

33,980 views