scn time
set pages 999
select scn
,      to_char(time_dp, ‘hh24:mi:ss dd/mm/yyyy’) time
from   smon_scn_time
order by scn
/
set pages 999
select scn
,      to_char(time_dp, ‘hh24:mi:ss dd/mm/yyyy’) time
from   smon_scn_time
order by scn
/
Discussion ¬