We are in 18C on windows. i am not sure why am i getting this wrong. I appreciate your feedback.
Wrote file afiedt.buf
1 select operation,target,to_char(start_time,'MM:DD:YY HH24:MI') AS START,to_char(END_time,'MM:DD:YY HH24:MI'),status
2 FROM dba_optstat_operations
3 where start_time > (sysdate -12/24)
4* ORDER BY 2 DESC
SYS@ERMESPRD1> /
select operation,target,to_char(start_time,'MM:DD:YY HH24:MI') AS START,to_char(END_time,'MM:DD:YY HH24:MI'),status
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected