SET LINES 120
COL NEXT FORMAT A30
COL NAME FORMAT A30
SELECT NAME, TO_CHAR(LAST_REFRESH, 'DD/MM HH24:MI"h"' ) "LAST REFRESH",
       NEXT, CAN_USE_LOG, STATUS, REFRESH_MODE, PREBUILT
FROM DBA_SNAPSHOTS WHERE OWNER='SCHEMA'
order by prebuilt desc
/