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

weixin_58555736 2022-02-17 11:04:29

 

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

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

你的前面字段是什么类型呢?是字符串还是日期呢?

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

1.7w+

社区成员

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