extract 썸네일형 리스트형 sql query SQL> SELECT EXTRACT ( YEAR FROM SYSDATE) FROM DUAL; EXTRACT(YEARFROMSYSDATE) ------------------------ 2010 SQL> select hire_date, 2 hire_date + to_yminterval('01-02') as hire_date_yminterval 3 from employees 4 where department_id =20; HIRE_DAT HIRE_DAT -------- -------- 96/02/17 97/04/17 97/08/17 98/10/17 SQL> select employee_id, manager_id, department_id 2 from employees 3 where (manager_id, de.. 더보기 이전 1 다음