I am executing the below sql statement and facing this error
"SELECT t.i_id,
to_char(t.open_time +4/24,'dd-mon-yy hh24:mi') open_time,
t.opened_by,
to_char(t.close_time+4/24,'dd-mon-yy hh24:mi') close_time,
t.title,
dbms_lob.substr(t.description,1000) description
FROM INCIDENTSM1 t
where t.OPEN_TIME >= to_date(@startt) AND t.OPEN_TIME < to_date(@endd) AND t.INCIDENT_ID IN (SELECT DISTINCT a1.INCIDENT_ID FROM INCIDENTSA1 a1 ) ;"
and passing startt and endd as parameters
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.
any one have an idea