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

weixin_58555736 2022-02-17 10:58:21

 

 

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')';

...全文
202 1 打赏 收藏 举报
写回复
1 条回复
切换为时间正序
请发表友善的回复…
发表回复

求大神帮忙

  • 打赏
  • 举报
回复
发帖
基础和管理

1.7w+

社区成员

Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
帖子事件
创建了帖子
2022-02-17 10:58
社区公告
暂无公告