• 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!
September 26, 2014 Uncategorized

Openworld day minus 3

Its day minus 3, or day +1 depending on your point of view at Openworld 2014. I’m here a few

Continue reading

September 6, 2014 Uncategorized

Openworld bound..

I’ll be in Openworld again this year, and have a couple of speaking slots… I’ll talk about new features for

Continue reading

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

Posts navigation

«Previous Posts 1 … 62 63 64 65 66 … 74 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

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • Is "fragmentation" still a dirty word?
    • Implementing dynamic partitions AND subpartitions
    • No more stale statistics in 19c
    • DBMS_JOB and 19c - code changes needed
    • How to upgrade to Oracle 19.8 on Windows
    • Some "must-have" ideas for your next meetup
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 863 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...