• 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!

Tag: techtip

January 31, 2020 Uncategorized

New LINESIZE settings for SQLPlus

Anyone that has used SQL Plus since its inception will be familiar with this frustration: There is my window, with

Continue reading

May 14, 2018 Uncategorized

From file names to directory hierarchy

I had a fun request come in from a colleague the other day.  They had a simple list of fully

Continue reading

January 25, 2018 Uncategorized

Those pesky LONG columns

There was a time, many moons ago when CLOB, BLOB and BFILE did not exist as data types. So if

Continue reading

January 23, 2018 Uncategorized

Dealing with IP addresses

Kris Rice made mention on Twitter about the free (but limited lifetime) IP address to Country mappings that you can

Continue reading

December 12, 2017 Uncategorized

iASH–my “infinite ASH” routine

I love Active Session History (ASH) data because a lot of the work I’ve done in my consulting life was

Continue reading

November 1, 2017 Uncategorized

Parsing freeform data in flat files

SQL loader is a very cool utility that has existed for a long time within Oracle to load flat files

Continue reading

October 15, 2017 Uncategorized

Buzzword Bingo

Looking for that catchy title for your next presentation ? I took the first word from the title of 1000

Continue reading

September 23, 2017 Uncategorized

AskTOM TV–episode 11

Just a quick note to give the supporting collateral to the latest episode of AskTOM TV. The question I tackled

Continue reading

September 22, 2017 Uncategorized

OpenWorld 2017–where is the tech content ?

I can’t actually remember how many OpenWorld conferences I have attended. At a guess it would be around 7 or

Continue reading

August 16, 2017 Uncategorized

AskTOM–more experts to help you!

I’m thrilled to announce the “formal” addition of globalization and characterset guru Sergiusz Wolicki to the AskTOM team. I say

Continue reading

Posts navigation

1 2 3 … 5 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
    • Why I blog
    • Let's talk about Techiquette
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • How to TREAT data in a CLOB as JSON
    • How to generate random unique values
    • Implementing dynamic partitions AND subpartitions
    • INITRANS grabs a little more space
    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...