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 [...]
oracle
SQL Magic Trick: Getting Row Count Without Fetching All Rows
So while hanging out with a bunch of co-workers last week, someone mentioned they had this trick. The challenge is knowing how many rows you have in your result set before you actually read them all. You see, Oracle has no way of telling us how many records are in our data set before we [...]
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 [...]
SQL Developer Data Modeler Quick Tip: Use Oracle JOIN Syntax or ANSI
New for version 3.1, currently available as a EA download, when defining the queries used to populate views, the modeler can generate JOINs using either Oracle’s or the standard ANSI compliant syntax. Let’s step back a second. When working with a VIEW defined in a relational model, the modeler has twp choices for defining the [...]
Twitter
RSS
GooglePlus
Facebook