Tag: reports

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

Similar Posts by Subject Areas: , , ,

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

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer Reporting 101

150 of my closest friends, or some random people on the Internet, joined me today while we talked all about SQL Developer’s reporting feature. Did you miss it? If so, I’m guessing you’re not a member of ODTUG. They put on free webcasts for everyone in the Oracle technology space. If you’re a member, you […]

Similar Posts by Subject Areas: , , ,

How To Add Custom Actions To Your User Reports

I’ve shown you and more than a few customers how to customize your Monitor Sessions page/report. If you need a refresher, that’s here. But basically it comes down to this: Copy the report from the Database Administration section of the Reports panel Paste it to the User Defined Reports section Edit to your heart’s delight […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer’s Best Kept Secret: Reports

The feature that everyone knows about yet does not use? That would be the reports. I say that everyone knows about them because we throw them in your least in terms of the user interface. It’s feature prominently next to where you see your database connections and objects. Yet, when I ask a room […]

Similar Posts by Subject Areas: ,

Reporting Enhancements for Oracle SQL Developer v4

This feature is going to be hard to cover in a single post, but I’m going to try anyway. The Reports interface received performance improvements, a few tweaks to make them easier to build, a slew of new charting options, and more visual control to tweak. Oh, it’s also available via the command-line interface. Let’s […]

Similar Posts by Subject Areas: , , ,

SQL Developer 4.0 and the Command Line Interface (CLI)

SQL Developer has had a command-line interface of sorts. The primary use cases were for formatting files and running unit tests. However, we wanted to expand the support to include things like generating Carts and running reports. Instead of just creating a few more one-off interfaces, we kind of started over and built a new […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer Data Modeler: What Tables Aren’t In At Least One SubView?

Organizing your data model makes the information easier to consume. One of the organizational tools provided by Oracle SQL Developer Data Modeler is the ‘SubView.’ In a nutshell, a SubView is a subset of your model. The Challenge: I’ve just created a model which represents my entire ____________ application. We’ll call it ‘residential lending.’ Instead […]

Similar Posts by Subject Areas: , , ,

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,