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

December 6, 2022 Uncategorized

Faster operations with CLOBs

Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less

Continue reading

March 4, 2021 Uncategorized

Extended VARCHAR2 and the hidden LOB

In 12c, there was much rejoicing when VARCHAR2 columns could be extended from beyond their current 4000 byte limit to

Continue reading

January 4, 2021 Uncategorized

"Big Mac and Size"..Handling large SQL Macros

Happy 2021 everyone! And what better way to start than a cheesy pun to make you groan and already to

Continue reading

April 7, 2020 Uncategorized

PGA memory consumption with BLOBs

Probably the most common usage for large objects (CLOBs and BLOBs) is to store them in a database table. In

Continue reading

March 26, 2020 Uncategorized

LOBs are larger in multibyte databases

Most customers I encounter nowadays are generally sticking to the defaults when creating their databases from 12c onwards. This means

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

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
    • No more stale statistics in 19c
    • How to generate random unique values
    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