I wrote this on LinkedIn, but that platform doesn’t play nice with Flipboard, and not all of you are connected with me there. So, if you Twitter, take a second and follow these people. You can thank me later. If you’re looking to follow even …
A Place to Learn Oracle, No Setup Required
I answered this question on Quora yesterday: What are the best resources for learning Oracle Database? The biggest learning curve to learning Oracle Database, SQL, PL/SQL, and all the other cool technologies that come with our database, is figuring out how to download, install, and …
Some Oracle Bloggers You Should Check Out
There’s tons of great info out there. Sometimes you just need help finding it. Here are some bloggers you should subscribe to. Not everyone can publish daily or even weekly, but these folks, when they DO publish, put out good, solid stuff. And many of …
If You Oracle Then You Should Twitter Too
Kellyn PotVin-Gorman and I have delivered a social media talk at the RMOUG Training Days Conference two years running now. We have fun doing the presentation, because we have fun being active on social media. We want you to not miss out on what we …
Java 8 on a Mac with SQL Developer 4.1
I ran into a few dramas getting SQL Developer 4.1 on my MacBook Air going earlier today. It boiled down to convincing SQL Developer to find and use the proper JDK on OS X Yosemite. So just in case it’s not me out there, here’s …
My Advice For Our New Hires
So for some reason, our New Hire Program invited me BACK to talk to our newly hired developers. I had an hour to talk about our development tools, but I wouldn’t call it training really. My colleague Joel does an actual 2 hour lab teaching …
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. …
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 …
Sweet Child Report O’ Mine
Updated: April 13, 2015 Reports are great ways to access data on demand without having to write and run the code over and over. Sometimes you want to take the results of a query and feed it to another query as an input or parameter. …