SQL Developer Reports: Reference Lines in Charts

thatjeffsmith SQL Developer 0 Comments

The ubiquitous HR.EMPLOYEES table – how many different ways can we look at this data? How much money people make, by department? By reading the column comments, we know that HR.EMPLOYEES.SALARY is “Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min)” So let’s chart that. This charts the data we get back from SELECT avg(SALARY), …