ORA-01438: 值大于为此列指定的允许精度 问题查找

1 SELECT ‘SELECT ‘‘‘||COLUMN_NAME||‘‘‘ AS COL_CODE, COUNT(*) AS COL_CNT FROM ‘||TABLE_NAME||‘ WHERE ‘|| 
2        CASE WHEN DATA_SCALE = 0 THEN ‘LENGTHB(TO_CHAR(‘||COLUMN_NAME||‘)) > ‘||DATA_PRECISION
3              ELSE ‘(INSTR(TO_CHAR(‘||COLUMN_NAME||‘),‘‘.‘‘) > 0 AND LENGTHB(SUBSTR(TO_CHAR(‘||COLUMN_NAME||‘),INSTR(TO_CHAR(‘||COLUMN_NAME||‘),‘‘.‘‘)+1,LENGTH(TO_CHAR(‘||COLUMN_NAME||‘)))) > ‘||DATA_SCALE||‘) OR LENGTHB(SUBSTR(TO_CHAR(‘||COLUMN_NAME||‘),1,INSTR(TO_CHAR(‘||COLUMN_NAME||‘),‘‘.‘‘)-1)) > ‘||(NVL(DATA_PRECISION,38)-DATA_SCALE) END ||‘  UNION ALL ‘ AS TSQL 
4          FROM ALL_TAB_COLUMNS T WHERE T.TABLE_NAME = ‘表名‘ AND T.OWNER = ‘用户名‘ AND DATA_TYPE = ‘NUMBER‘;