ThatJeffSmith

Tag: reports

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: , , , , , ,