• 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

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

September 24, 2018 Uncategorized

Datatype conversion laziness … yet another reason

I’ve got two words to describe my thoughts on being lazy with data types …. JUST DON’T! There’s been many

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

  • How to do a GRANT on an entire schema
  • End of an era …
  • Why you keep getting "ORA-01653: unable to extend table"
  • Natural Keys versus Surrogate Keys….Here we are again!
  • How to TREAT data in a CLOB as JSON
  • Connection shortcuts with a wallet
  • No more stale statistics in 19c
  • Don't run tight on PGA
  • Pluggable database and restricted sessions
  • Powerpoint hack for tech presenters
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 824 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...