> ORA-00932: inconsistent datatypes: expected NUMBER got CHAR 小白求大神查错

最新推荐文章于 2022-06-15 11:28:32 发布

原创

最新推荐文章于 2022-06-15 11:28:32 发布 · 794 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

报错> ORA-00932: inconsistent datatypes: expected NUMBER got CHAR

SELECT t0.fid, t1.FNUMBER fnumber1,t1_l.FNAME fname1,
t2.FNUMBER fnumber2,t2_l.FNAME fname2,
t3.FNUMBER fnumber3,t3_l.FNAME fname3,
t4.FNUMBER fnumber4,t4_l.FNAME fname4,t5.FNUMBER fnumber5,t5_l.FNAME fname5,
t6.FNUMBER fnumber6,t6_l.FNAME fname6,t7.FNUMBER fnumber7,t7_l.FNAME fname7,
t8.FNUMBER fnumber8,t8_l.FNAME fname8,
SUBSTR(((((((CASE WHEN (t1.FNUMBER IS NOT NULL )
THEN (’/’ + t1.FNUMBER)
ELSE ‘’ END +
CASE WHEN (t2.FNUMBER IS NOT NULL )
THEN (’/’ + t2.FNUMBER)
ELSE ‘’ END) +
CASE WHEN (t3.FNUMBER IS NOT NULL )
THEN (’/’ + t3.FNUMBER)
ELSE ‘’ END) +
CASE WHEN (t4.FNUMBER IS NOT NULL )
THEN (’/’ + t4.FNUMBER)
ELSE ‘’ END) +
CASE WHEN (t5.FNUMBER IS NOT NULL )
THEN (’/’ + t5.FNUMBER)
ELSE ‘’ END) +
CASE WHEN (t6.FNUMBER IS NOT NULL )
THEN (’/’ + t6.FNUMBER)
ELSE ‘’ END) +
CASE WHEN (t7.FNUMBER IS NOT NULL )