• 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: external table

January 2, 2023 Uncategorized

TEMP is a four letter word

Happy New Year to all! With the next long term release (23c) probably due some time this year, let’s start

Continue reading

July 9, 2021 Uncategorized

Keeping OPatch updated with a simple SQL query

I tweeted out this pic yesterday which suggested that by running a SQL query, I could magically keep my OPatch

Continue reading

November 6, 2020 Uncategorized

Application Express – the PSE update

I published a post a couple of days ago about how due to the architecture of PL/SQL and hence Application

Continue reading

April 30, 2020 Uncategorized

Why you might add columns to external tables

Let me start with the idiotic part first. That part would be…. me! I’ll create an external table which reads

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 you keep getting "ORA-01653: unable to extend table"
    • How to TREAT data in a CLOB as JSON
    • Extended VARCHAR2 and the hidden LOB
    • How to generate random unique values
    • Modifying tables without losing materialized views
    • No more stale statistics in 19c
    • Free In-memory in Oracle Database 19c
    • Generating INSERT scripts that run fast!
    • 19c Express Edition #JoelKallmanDay
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 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