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

[weixin_58555736]

 

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

[风过茶易凉]

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