编写数据库脚本时，编辑日期类型字段错误，跪求大神帮助

2022-02-17 10:58:21 369 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

weixin_58555736 墨衍会员 · AI 创作全网分发关注 + 加入社区

easyExcel中使用String类型去接收Date日期类型问题通过上述问题排查,知道了问题最后生成的原因,解决方法也很明确,即将创建时间的字符串类型更换为Date日期类型,再次导出Excel,日期数据正确.一个类型的错误使用,引发了一个不大不小的bug. 对于代码的修改和测试,还需要认真仔细,减少bug的出现.本文到此结束,一天一个bug系列,不希望有下次!拜拜了您嘞。阅读详情

PROCEDURE USR_QLJFW.T_JOB_JKDT 编译错误

错误：PLS-00103: Encountered the symbol "YYYY" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem return
returning <an exponent (**)> <> or != or ~= >= <= <> and or
like like2 like4 likec between into using || multiset bulk
member submultiset
The symbol "*" was substituted for "YYYY" to continue.
行：12
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'YYYY-MM-DD')';

错误：PLS-00103: Encountered the symbol ")" when expecting one of the following:

. ( * @ % & = - + ; < / > at in is mod remainder not rem
return returning <an exponent (**)> <> or != or ~= >= <= <>
and or like like2 like4 likec between into using || bulk
member submultiset
The symbol "*" was substituted for ")" to continue.
行：12
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'YYYY-MM-DD')';

错误：PLS-00103: Encountered the symbol "YYYY" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem return
returning <an exponent (**)> <> or != or ~= >= <= <> and or
like like2 like4 likec between into using || multiset bulk
member submultiset
The symbol "*" was substituted for "YYYY" to continue.
行：29
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'yyyy-mm-dd')';

错误：PLS-00103: Encountered the symbol ")" when expecting one of the following:

. ( * @ % & = - + ; < / > at in is mod remainder not rem
return returning <an exponent (**)> <> or != or ~= >= <= <>
and or like like2 like4 likec between into using || bulk
member submultiset
The symbol "*" was substituted for ")" to continue.
行：29
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'yyyy-mm-dd')';