• About
  • All Posts
  • 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

Tag: clob

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.

Top Posts & Pages

  • 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
  • APEX 20.2 comes to town (well, to my PC)
  • LOBs from afar
  • My APEX was fine and then it wasn't
  • Updating indexes with partition maintenance
  • Pluggable database and restricted sessions
  • NULL's vs NOT NULL's and Performance
  • Generating INSERT scripts that run fast!
Blog at WordPress.com.