ThatJeffSmith

Tag: reports

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 face..at 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 [...]

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

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

Oracle SQL Developer Report: Tables By DataType

When I’m doing demonstrations of Oracle SQL Developer, I’m frequently asked about our support for datatypes like XML, BLOBS, Timestamp, etc. When I’m put on the spot like that, I have a tendency to forget that I already have tables setup for this. So I end up writing a query to find a table that [...]

Grandparent – Parent – Child Reports in SQL Developer

Parent – Child reports are pretty straightforward in Oracle SQL Developer. You have a ‘parent’ report, and then one or more ‘child’ reports which are based off of a value in a selected row or value from the parent. If you need a quick tutorial to get up to speed on the subject, go ahead [...]

Customizing Monitor Sessions in Oracle SQL Developer

Want to monitor or browse the sessions running on your database? You could query v or gv$session and get an idea of what’s happening. But often you want and need to join into waits, locks, performance data, plans, etc. to get a full picture of what your users and applications are doing in the database. [...]

Including BLOB images in your PDF Reports

You have data and lots of it. Some of this data includes images. You store them in your Oracle tables as Binary Large Objects (BLOBs.) You build reports using Oracle SQL Developer. Now you want to make those images in your tables available to your reports, and more importantly, to the end users reading said [...]

Substitution Variables & HTML Reports in SQL Developer

Martin asks – I am searching for any method to pass any table name to a sql statement in a self-written report. My initial response was to quote Lewis’ article in Oracle Magazine where he discusses bind variables, Making the Most of Oracle Developer Reports. So binds work, but what about SQL*Plus Substitution Variables? You’ve [...]

How To Build A Report with Multiple Children

I was asked recently if SQL Developer supported multiple children reports. The answer is ‘yes’, and here is a post showing how to achieve this. First I need to clarify the answer a bit. Reports have a ‘master’ record set. These records can be used to ‘look up’ related records in a ‘detail’ set. This [...]

Average Run Time for Oracle Jobs

Starting with 10g and the introduction of DMBS_SCHEDULER, Oracle database began tracking and storing the execution duration of a job. By default this information is kept around for 30 days. You can of course change the logging level and the retention period for the job runs – read the docs! The job runs can be [...]

Sweet Child Report O’ Mine

I am just getting my feet wet when it comes to the reports in SQL Developer. The tool itself has quite a lot going on, everything from a database IDE to a migration platform, to a data modeling component. And then throw in the reporting stuff. I’ve already covered how to build a simple bar [...]

Simple Bar Chart Reports with SQL Developer

There are many good articles out there that go into detail for creating reports with Oracle SQL Developer. I was reading my predecessor’s write up in Oracle Magazine (May 2007) on the subject, and keyed into the following snippet: Building a Chart When creating a report with the Chart style, the rule of thumb is [...]