Faster operations with CLOBs
Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less
Tag: clob
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
"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
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
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
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
Learning is not a spectator sport 