Oracle Alterar Formato da Data sqlplus

ALTER SESSION SET NLS_DATE_FORMAT = ‘HH24:MI:SS’;

SELECT SYSDATE FROM DUAL;

select to_char(sysdate,’DD MM YYYY HH24:MI:SS’) from dual;
select to_char(sysdate,’ MM YYYY’) from dual;