SEKECT ENAME SAL, JOB, HIREDATE, DEPTNO
FROM EMP
WHERE ENAME = 'SCOTT';
SELECT ENAME, HIREDATE
FROM EMP
WHERE HIREDATE = '81/11/17';
SELECT *
FROM NLS_SESSION_PARAMETERS
WHERE PARAMETER = 'NLS_DATE_FORMAT';
ALTER SESSION SET NLS_DATE_FORMAT = 'YY/MM/DD';