Creating a Reporting ‘Dashboard’ in SQL Developer

thatjeffsmith SQL Developer 4 Comments

Haven’t had much time to blog this week, so what’s a blogging addict to do? Ask your readers for help! @thatjeffsmith kind of like db instance but more focused. I picked 3 just to give an idea. Refresh would be on all. pic.twitter.com/WUlWyUbeT3 — Nando Somoza (@slaytanic70) September 10, 2015 So I put together this view for Nando…3 reports running …

How to Share Reports

thatjeffsmith SQL Developer 11 Comments

Reports are one of my favorite features. If you don’t use them in SQL Developer, please read this. The user interface for user defined reports is very simple in SQL Developer. Maybe even, too simple? Sometimes I tell folks to save and/or copy their reports around. And it’s not exactly apparent how to do this at first glance. Of course, …

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), …