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

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 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

September 11, 2015 Uncategorized

Longer strings in 12c

Most people are now aware that in 12c, a VARCHAR2 has been extended from a maximum size of 4000 to

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

  • Blockchain tables are here in 19c!
  • Archives
  • How to do a GRANT on an entire schema
  • No more stale statistics in 19c
  • My APEX was fine and then it wasn't
  • Pluggable database and restricted sessions
  • APEX 20.2 comes to town (well, to my PC)
  • Extended VARCHAR2 and the hidden LOB
  • Complex materialized views and fast refresh
  • Why you keep getting "ORA-01653: unable to extend table"
Blog at WordPress.com.