• 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!
October 6, 2015 Uncategorized

Evolution

I’m a bit of a dinosaur when it comes to how long I’ve been using Oracle.  But you should never

Continue reading

September 25, 2015 Uncategorized

exitcommit … or your career down the drain

I recently posted a little video on the ‘exitcommit’ option in SQL Plus, adding a theatrical drama to present a

Continue reading

September 21, 2015 Uncategorized

Connection shortcuts with a wallet

I’m lazy when I connect to the database, especially on my laptop.  Anything that saves a few keystrokes I’m keen

Continue reading

September 18, 2015 Uncategorized

Row transposition

Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as:

Continue reading

September 14, 2015 Uncategorized

Lets Talk DB Perth

Last week in Perth, we held a “Lets Talk DB” event.  This was a free event organised by our local

Continue reading

September 11, 2015 Uncategorized

Longer strings in 12c

Most people are now aware that in 12c, a VARCHAR2 has been extended from a maximum size of 4000 to

Continue reading

August 28, 2015 Uncategorized

Presenting in Perth on September 9th, 2015

I’ll be presenting at a “Lets Talk Oracle” event in Perth, with fellow Ex-Oracle ACE Directors Richard Foote and Chris

Continue reading

August 25, 2015 Uncategorized

Less calls…more performance (part 2)

In the previous post, I mentioned that for a programming environment fetching rows from the database, then the method of

Continue reading

August 25, 2015 Uncategorized

Less calls…more performance

In various programming environments, a common metaphor is to open a cursor on the database (a REF CURSOR in Oracle

Continue reading

August 21, 2015 Uncategorized

Avoiding public embarrassment with triggers

If you create a trigger that does not compile, any part of your application that refers to the table with

Continue reading

Posts navigation

«Previous Posts 1 … 57 58 59 60 61 … 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
    • Let's talk about Techiquette
    • Adding APEX 23.1 to your Database Free VM
    • Why I blog
    • How to do a GRANT on an entire schema
    • Implementing dynamic partitions AND subpartitions
    • How to generate random unique values
    • How to TREAT data in a CLOB as JSON
    • Is "fragmentation" still a dirty word?
    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...