Top 60 Oracle Blogs

Recent comments

March 2013

New OakTable World 2012 video is published

Just published Kevin Closson video from OakTable World 2012.

Implementing attribute and tuple constraints

In our previous post we have introduced a classification scheme for data integrity constraints. In todays post we will present thoughts & guidelines around how to implement the first two classes:  attribute and tuple constraints.

The examples given in the previous post were:

I’m so bleeding edge…

I forgot to mention the really big news from this last week at work. I have been upgraded from Windows XP to Windows 7! I feel so bleeding edge now. I switched to classic theme, so it feels like XP. :)

I’ve also been switched from Office XP to Office 2010, so I now have that ribbon thing. I think I need a bigger monitor now that ribbon takes most of my screen. :)

Joking aside, the transition has been really easy and things seem to be working fine. Not sure how long it will take before the first official installations of Windows 8 hit our place. I’ll happily stay behind the bleeding edge on that one. :)



How can we make Oracle Database 12cR2 the best release ever?

Oracle will be releasing Oracle Database 12cR1 at some point this year. Many companies will avoid this release, opting to wait for 12cR2, their reasoning being it will be more stable and, as a terminal release, will have a longer support life-cycle. Since 12cR2 is what most businesses care about, what can we do to make it as good as it can possibly be? Here are a few thoughts…

Data integrity constraint classification

Before we start investigating the complexities involved in implementing data integrity constraints using database triggers, we will first introduce a classification schema for data integrity constraints. Agreeing upon a classification scheme for constraints, helps us a lot in implementing them: for we can then approach the problem area on a class-by-class basis.

A classification scheme needs to have a few properties:

My current love/hate relationship with working in IT…

I wrote the following tweet the other day.

I love technology, but hate working in IT. The politics and bullshit drag you down… :( #baddayatwork

— Tim Hall (@oraclebase) February 28, 2013

I’ve been known to say on numerous occasions,

“Sometimes, a bad decision is better than no decision at all!”

I’m currently reading God Emperor of Dune by Frank Herbert and I just read this passage, which is a conversation between Leto (The God Emperor) and an Ixian Ambassador.

Source Control

You may recall that I spent some time with the developers at the redgate offices in Cambridge (UK) a little while ago, looking at their Source Control for Oracle package. The product is about to go live, with a launch date of 12th March.

Because of the help I’ve given them they’ve offered my readers the chance of winning one of two 5-user licences for the product – provided I devise a strategy for picking the recipients.

Friday Philosophy – Do good DBAs need PL/SQL Skills?

This Friday Philosophy was prompted by a discusion between some OakTable people about did we think “good” DBAs should know PL/SQL? Not all the tricks, bulk processing, using all the built-ins, but able to write PL/SQL with cursor loops and some exception handling that could eg cycle thorough tables and archive off data or implement some logon trigger functionality.

My response was “that depends on the age of the DBA”.

If you had asked me that question 15 years ago I would have said Yes, a good DAB would and should know PL/SQL.
If you had asked me 10 years ago I would have said I’d hope they would and most DBAs I respected has some PL/SQL skills.
If you had asked me 5 years ago I would have sighed and had a little rant about how they should but the younger ones don’t and that is wrong.

Secret Hacking Session: Find Out How Oracle SQL Plans Are Really Executed!

Yes, I am going to run a yet another secret hacking session next week!

  • Title: Secret Hacking Session: How Oracle SQL Plans Are Really Executed!
  • Date: Tuesday, March 5, 2013
  • Time: 10:00 AM – 12:00 PM PST



This is not a yet another talk about how to extract and display execution plans.

It is also not a theoretical talk about how to read execution plans in general.

You should know this stuff already :)