java执行一条sql语句 运行时报ORA-01481:invalid number format model 急急急!!!
小孔大胖 2017-10-21 11:36:38 String sql = "select distinct * " +
"from JL_SITEDIFF_DETAIL_NOW j where first_result=to_date(to_char('"+timemember+"','yyyy-mm-dd'),'yyyy-mm-dd') and not exists (select address1,address2 from YITE_SAME_WHITELIST b where (b.address1||b.address2=j.sitecode1||j.sitecode2 or b.address1||b.address2=j.sitecode2||j.sitecode1))";