-
test of invalid characters
I'm attempting to identify invalid characters stored in a varchar2 column.
Despite it's format, it represents the invoice number in Oracle Receivables.
Unfortunately, I am trying to do a comparison between the 'number' stored and a range of numbers. Because there are a few rows with other ascii characters stored, I'm getting an ora-01722: invalid number returned.
Does anyone have a script which can check for those records with an invalid value?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|