阅读背景:

查找Oracle中不包含数字数据的行

来源:互联网 

I am trying to locate some problematic records in a very large Oracle table. The column should contain all numeric data even though it is a varchar2 column. I need to find the records which don't contain numeric data (The to_number(col_name) function throws an error when I try to call it on this column).I am trying to locate some problematic records




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: