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

April 6, 2021 Uncategorized

UNLONG my dictionary – those pesky LONG columns

We’ve have all seen those TV crime shows where the psychiatrist does word association games, such as: Question: “Blue?” Answer:

Continue reading

July 29, 2020 Uncategorized

How to TREAT data in a CLOB as JSON

What better way to start a new week than with a cheesy title to my blog post! But there is

Continue reading

June 25, 2020 Uncategorized

MAX_STRING_SIZE and the data dictionary

This post cycles back too some other historical posts of mine related to max_string_size and the fact that the data

Continue reading

June 18, 2020 Uncategorized

Take care with Read-Only partitions in 18c

The ability for part of a table to be read-only and other parts of the same table to allow full

Continue reading

March 17, 2016 Uncategorized

Views as “stored text”

You’ll often see comments that views are not copies of the data, they are merely the stored text of a

Continue reading

March 13, 2014 Uncategorized

views in 12c

Observed an interesting idiosyncracy in the creation of views in 12c (this is in a pluggable database, but not confirmed

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

    • How to do a GRANT on an entire schema
    • Why I blog
    • Why you keep getting "ORA-01653: unable to extend table"
    • Adding APEX 23.1 to your Database Free VM
    • No more stale statistics in 19c
    • How to TREAT data in a CLOB as JSON
    • Implementing dynamic partitions AND subpartitions
    • INITRANS grabs a little more space
    • Bringing Multimedia back into 19c!
    • How to generate random unique values
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 864 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