• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!
August 17, 2014 Uncategorized

MERGE and IOT’s ….. unhappy bedfellows

Anyone who has used Oracle for a while will be familiar with the Parent/Child locking “issue” when it comes to

Continue reading

August 9, 2014 Uncategorized

12c – Nested tables vs Associative arrays

This was going to the be the immediate follow up to my previous post, but 12.1.0.2 came out and I

Continue reading

August 9, 2014 Uncategorized

12.1.0.2 security grrr…

One of my favourite security “tricks” used to be the following: SQL> [create|alter] user MY_USER identified by values ‘impossible’; Looks

Continue reading

July 14, 2014 Uncategorized

Associative arrays and Nested tables

A common criticism of PLSQL is that the “original” array datatype, now called associative arrays are perfect for passing stuff

Continue reading

July 6, 2014 Uncategorized

No Hakan factor for IOT

Sadly there seems to be no concept of the Hakan factor for an IOT. I have an application which merges

Continue reading

June 29, 2014 Uncategorized

12c nasty with remote query optimization

We have a fairly common query process, where we run a MERGE command to compare a remote table to a

Continue reading

June 29, 2014 Uncategorized

Testing…the surgeon’s approach

I played a lot of volleyball in a bygone life 🙂 and subsequently ruined my knees to the extent that

Continue reading

June 29, 2014 Uncategorized

Upgrade to 12c … credentials

We did a “real” upgrade to 12c this weekend, where “real” means a production system, as opposed to my laptop,

Continue reading

April 26, 2014 Uncategorized

Dumb triggers part 2 – session level control

In the previous post, I pontificated about triggers that “lock you in” to having them fire, which can create dramas

Continue reading

April 24, 2014 Uncategorized

Really dumb triggers

Some people hate triggers, some people love triggers… I am not that opinionated on them in either direction, but one

Continue reading

Posts navigation

«Previous Posts 1 … 61 62 63 64 65 … 73 Next Posts»

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Tweets by connor_mc_d

    Top Posts & Pages

    • SQL engine and PL/SQL functions
    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • No more stale statistics in 19c
    • A new use for DML error logging
    • How to TREAT data in a CLOB as JSON
    • How to generate random unique values
    • Getting a dog improved my productivity
    • Automatically generate audit capture for tables
    • Archives
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 846 other followers
      • Already have a WordPress.com account? Log in now.
      • Learning is not a spectator sport
      • Customize
      • Follow Following
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar
     

    Loading Comments...