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

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

Similar Posts by Subject Areas: , , , ,

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

Similar Posts by Subject Areas: , ,

SQL Developer Data Modeler v3.3 Early Adopter: Collaborative Design via Excel?

As you may have heard last week, we have a new version of Oracle SQL Developer Data Modeler now available as an Early Adopter release. Version 3.3 has quite a few new features and I’ll be previewing them here. Today’s topic is our new Excel integration. It builds off of last week’s lesson: Search, so […]

Similar Posts by Subject Areas: , , ,

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

Similar Posts by Subject Areas: , , ,

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

Similar Posts by Subject Areas: , ,

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

Similar Posts by Subject Areas: , ,

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

Similar Posts by Subject Areas: ,

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , , , ,