• 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: datatypes

August 26, 2022 Uncategorized

XMLTABLE and data “corruption”

One of the cool things with the native SQL handling of complex datatypes is the ability to take something like

Continue reading

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

March 30, 2021 Uncategorized

Column names you should NOT use

We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good

Continue reading

February 9, 2021 Uncategorized

Expanded TYPE definitions for PL/SQL 21c

There has always been that odd conflict between the language you use for SQL versus the language you use for

Continue reading

January 27, 2021 Uncategorized

Datatype conversions – strange internal function

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to

Continue reading

July 8, 2019 Uncategorized

HIGH_VALUE (and other LONG columns) revisited

Just a quick post to ensure people don’t get caught out by a recent “trick” I saw on an AskTOM

Continue reading

April 29, 2019 Uncategorized

Raw partitions?

Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition

Continue reading

April 16, 2019 Uncategorized

PL/SQL – Don’t mix and match scope

Here’s a simple little PL/SQL block where we call an inner procedure PARAMETER_TESTER from its parent block. Pay particular attention

Continue reading

December 29, 2018 Uncategorized

Another day…another "use the right datatype" post

Here’s an interesting little oddity (aka bug) with scalar queries. We’ll start with a simple working example SQL> create table

Continue reading

September 27, 2018 Uncategorized

Correcting datatypes with minimal downtime

Just a quick post here by request of an attendee of the September Office Hours. I had a demo converting

Continue reading

Posts navigation

1 2 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
    • How to do a GRANT on an entire schema
    • Implementing dynamic partitions AND subpartitions
    • Is "fragmentation" still a dirty word?
    • INITRANS grabs a little more space
    • Why I blog
    • No more stale statistics in 19c
    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...