报错> 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 )
TH