pls-00103:在预期出现以下情况之一时遇到符号“>”

ia2d9nvy  于 2021-08-09  发布在  Java
关注(0)|答案(0)|浏览(329)

我有下面的sql代码,当我运行它时,它给出了一个错误pls-00103:遇到符号“>”时,预期的一个following:. ( * @ % & = - + < / > 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**

有人能帮忙吗

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题