Hi I am a newbie in TD. I need your help in identifying the bad character on my table. I'm only expecting negative & positive numbers as my result.
column_abc CHAR(19) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT NULL ,
Thank you in advance.
You could use a REGEXP_SIMILAR, but the easiest way is
TO_NUMBER(column_abc), which simply returns NULL if it can't be converted to a numeric value.