syntax erroe
Could u plz guide me for right syntax for below query:
SQL> column UNXPSTEALCNT heading "# Unexpired|Stolen"
column EXPSTEALCNT heading "# Expired|Reused"
column SSOLDERRCNT heading "ORA-1555|Error"
column NOSPACEERRCNT heading "Out-Of-space|Error"
column MAXQUERYLEN heading "Max Query|Length"
select inst_id, to_char(begin_time,'MM/DD/YYYY HH24:MI') begin_time, UNXPSTEALCNT, EXPSTEALCNT , SSOLDERRCNT, NOSPACEERRCNT, MAXQUERYLEN
from gv$undostatwhere begin_time between to_date('','MM/DD/YYYY HH24:MI:SS') and to_date('','MM/DD/YYYY HH24:MI:SS')order by inst_id, begin_time;SQL> SQL> SQL> SQL> SQL> 2
from gv$undostatwhere begin_time between to_date('','MM/DD/YYYY HH24:MI:SS') and to_date('','MM/DD/YYYY HH24:MI:SS')order by inst_id, begin_time