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

Category: Uncategorized

July 8, 2022 Uncategorized

PL/SQL – choosing the BEST data type

Just a little bit of Friday fun with PL/SQL data types for this post. Let’s explore the performance differences when

Continue reading

July 7, 2022 Uncategorized

Kscope 22 – the joy of in-person conferences

Rather than bore you with a lengthy tome about the event, I’d thought I would summarise the week with pictures

Continue reading

a black and white picture of a womans face repeated several times
June 8, 2022 Uncategorized

Comparing two database objects for differences

Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL

Continue reading

a collection of crushed plastic bottles ready for recycling
May 30, 2022 Uncategorized

Recycling saves the planet but maybe not your database

The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card

Continue reading

a large bank safe locked shut
May 25, 2022 Uncategorized

Is my table marked for archive?

In 12c, we introduced a feature call Row Archival, which is a means of integrating typical archival models that we

Continue reading

a picture of the original hard copy oracle manuals from version 4 to version 8
May 13, 2022 Uncategorized

Version 7 was so much better…

Full disclosure: This is a rant post. If you’re not into ranting and pontificating, perhaps best to move along now

Continue reading

an old style wooden ruler with measurements from 1 to 10centimeter
May 12, 2022 Uncategorized

The Fractional Part of a TIMESTAMP. Be careful.

This discovery came in from an AskTom customer but I figured it’s worth passing on to any PL/SQL programmers out

Continue reading

a set of square shelves each holding various jars of spices being a metaphor for a database partitioned table
April 22, 2022 Uncategorized

Implementing dynamic partitions AND subpartitions

One of the cool things to come out of the partitioning option many moons ago was the feature known as

Continue reading

a couple obviously in love riding a single bike together through a field on a summer day
April 19, 2022 Uncategorized

DBMS_OUTPUT … A (formatting) love story

What happens when you want to serenade your partner with a romantic ditty, but you’re a database professional as well?

Continue reading

a woman at a laptop frustrated with coding
April 13, 2022 Uncategorized

My poor developers! PLSQL is going to be so hard on them!

So I started all of this by talking about how PLSQL is going to give you a performance boost, just

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 5 6 … 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...