我有下面的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**
有人能帮忙吗
暂无答案!
目前还没有任何答案,快来回答吧!