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
Tag: clob
"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 