ThatJeffSmith

Tag: report

Oracle SQL Developer Code Reports

It’s so much more fun to watch users demo and brag about your software than it is to get up and do it yourself. For one thing, it means a lot more coming from real people than it does coming from someone PAID to talk it up. Today, about 40 of us in Raleigh/Durham watched […]

SQL Developer Reports: Reference Lines in Charts

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 […]

Querying Your Oracle SQL Developer Data Modeler Designs

Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database. And when something is in a database, then […]

Database Diff Enhancements in Oracle SQL Developer v3.2

In the current issue of Oracle Magazine, I have an article that discusses how to copy and compare Oracle objects using Oracle SQL Developer. ‘Make the Easy Move‘ was written using Oracle SQL Developer v3.1. As you know, version 3.2 was released several weeks ago, and one of the significant changes included was an update […]