sql - PLS-00103：在预期以下情况之一时遇到符号“>”

Question

当我运行它时，我有以下 sql 代码，它给出了错误 PLS-00103：遇到符号“>”，当我期望以下之一时：。( * @ % & = - + < / > at in 是 mod 余数不是 rem

SELECT     n.id,
               n.ain,
               to_char(n.open_time +4/24,'dd-mon-yy hh24:mi') open_time,
               n.by,
               to_char(n.close_time+4/24,'dd-mon-yy hh24:mi') close_time,
               n.closed_by,
               n.contact_name,
               n.category,
               n.assignee_name,
               n.affected_item,
               n.medium,
               n.name,
               n.Status,
               n.escllated,
               to_char(n.actual_start+4/24,'dd-mon-yy hh24:mi') actual_start,
               to_char(n.actual_finish+4/24,'dd-mon-yy hh24:mi') actual_finish,
               n.actual_duration,
               n.title,
               dbms_lob.substr(n.description,3000) description
    FROM       MYTABLE n
    where      n.OPEN_TIME >= to_date('01-may-20') AND n.OPEN_TIME < to_date('18-may-20') AND n.INCIDENT_ID IN (SELECT DISTINCT a1.INCIDENT_ID  FROM   INCIDENTSA1 a1 ) ;

我收到以下错误

**Execute Query: ORA-06550: line 21, column 175:
PLS-00103: Encountered the symbol ">" when expecting one of the following:
   . ( * @ % & = - + < / > at in is mod remainder not rem
   <an exponent (**)> <> or != or ~= >= <= <> and or like like2
   like4 likec as between || multiset member submultiset
The symbol "( was inserted before ">" to continue.
ORA-06550: line 21, column 221:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
   . ( * % & = - + < / > at in is mod remainder not rem
   <an exponent (**)> <> or != or ~= >= <= <> and or like like2
   like4 likec as between || multiset member submultiset**

有人可以帮忙吗

标签： sqldatabaseoracle