Latest from the blog

HR Schema Queries and PL/SQL programs

May 22, 2016 Billy Aung Myint No comment

SELECT JOB_TITLE, DEPARTMENT_NAME, LAST_NAME, START_DATE FROM JOB_HISTORY JOIN JOBS USING (JOB_ID) JOIN DEPARTMENTS USING (DEPARTMENT_ID) JOIN EMPLOYEES USING (EMPLOYEE_ID) WHERE TO_CHAR(START_DATE,’YYYY’) BETWEEN 2000 AND 2005

Source: HR Schema Queries and PL/SQL …