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

March 7, 2023 Uncategorized

Avoiding INSERT glitches with SQL*Plus and SQLcl

Sometimes in data centric applications, we want to store metadata (such as HTML or CSS or other such text) in

Continue reading

February 2, 2023 Uncategorized

The new forums

New year and I knew you want some new news about new forums!  (That’s a lot of “new” 😀) I’ll

Continue reading

November 23, 2022 Uncategorized

Google-like search for your entire application

I published a video today showing how to use a Text index to pick up search terms from multiple tables

Continue reading

November 11, 2022 Uncategorized

I did not write this blog post

In fact…no-one wrote this blog post! Here’s a little bit of fun for you. I was doing my normal doom

Continue reading

November 9, 2022 Uncategorized

From stateful to stateless PL/SQL

I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little

Continue reading

November 1, 2022 Uncategorized

The Halloween Pumpkins of Terror

For some giggles this Halloween, over on Twitter I tweeted some worst practices each hour during Halloween in the guise

Continue reading

August 26, 2022 Uncategorized

XMLTABLE and data “corruption”

One of the cool things with the native SQL handling of complex datatypes is the ability to take something like

Continue reading

July 14, 2022 Uncategorized

Juice up your JSON on Autonomous

As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and

Continue reading

July 12, 2022 Uncategorized

Digging deeper into SQL under APEX

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.

Continue reading

July 8, 2022 Uncategorized

PL/SQL – choosing the BEST data type

Just a little bit of Friday fun with PL/SQL data types for this post. Let’s explore the performance differences when

Continue reading

Posts navigation

1 2 3 … 7 Next Posts»

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"
    • No more stale statistics in 19c
    • 19c Express Edition #JoelKallmanDay
    • How to TREAT data in a CLOB as JSON
    • The phantom tablespace
    • Connection shortcuts with a wallet
    • Automatically generate audit capture for tables
    • ORDS upgrades are so easy
    • HIGH_VALUE (and other LONG columns) revisited
    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
     

    Loading Comments...