A Place to Learn Oracle, No Setup Required

thatjeffsmith Database Stuff 5 Comments

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 create a database FIRST. And then of course you’ll have to configure a connection in …

Some Oracle Bloggers You Should Check Out

thatjeffsmith Database Stuff, General 18 Comments

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 these guys and gals will be at Open World and probably Pythian’s Blogger Party. If …

If You Oracle Then You Should Twitter Too

thatjeffsmith Personal Tech 3 Comments

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 get out of it every day. This morning I saw a tweet/blog post from Oracle …

My Advice For Our New Hires

thatjeffsmith Database Stuff 0 Comments

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 them to use APEX – that’s closer to REAL training. So given an hour, and …

Substitution Variables & HTML Reports in SQL Developer

thatjeffsmith SQL Developer 5 Comments

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 seen these before: & – …

Average Run Time for Oracle Jobs

thatjeffsmith Database Stuff, SQL Developer 7 Comments

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 viewed via the dba_scheduler_job_run_details SYS …

Sweet Child Report O’ Mine

thatjeffsmith SQL Developer 9 Comments

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. Wouldn’t it be great if you could fire off a report based on the selected …