Latest from the blog

Oracle Performance Tuning – Tracing Oracle

January 2, 2017 Billy AM No comment

Oracle Performance tuning – Tracing Oracle

An Oracle tracing process from various websites and tutorials I have read over the year. Hopefully , it helps someone to troubleshoot the issue. Also …

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 …