• 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

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

a couple obviously in love riding a single bike together through a field on a summer day
April 19, 2022 Uncategorized

DBMS_OUTPUT … A (formatting) love story

What happens when you want to serenade your partner with a romantic ditty, but you’re a database professional as well?

Continue reading

a woman at a laptop frustrated with coding
April 13, 2022 Uncategorized

My poor developers! PLSQL is going to be so hard on them!

So I started all of this by talking about how PLSQL is going to give you a performance boost, just

Continue reading

the end of an ethernet network cable
April 12, 2022 Uncategorized

A little bit of PLSQL and a little bit of network

So after my post yesterday about PL/SQL being a no-brainer to get an easy boost to application performance, there was

Continue reading

a running cheetah
April 11, 2022 Uncategorized

A little bit of PLSQL can be a huge win

I rarely blog about PLSQL for a very simple reason. It quickly becomes like Halloween night because all the ghouls

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 … 8 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

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Let's talk about Techiquette
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • Implementing dynamic partitions AND subpartitions
    • Is "fragmentation" still a dirty word?
    • INITRANS grabs a little more space
    • Why I blog
    • No more stale statistics in 19c
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 863 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...