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

January 11, 2021 Uncategorized

How long will the script take to run?

In a world where databases are now the norm, whereas distributing data via a CSV file used to be commonplace,

Continue reading

March 30, 2020 Uncategorized

Combinations and consequences

Fellow Perth techie Scott Wesley sent me this interesting puzzle recently. He was using the long awaited feature of being

Continue reading

May 17, 2019 Uncategorized

Generating INSERT scripts that run fast!

Most developers tools out there have some mechanism to unload a table into a flat file, either as CSV, or

Continue reading

May 2, 2019 Uncategorized

Partition loading in direct mode

Direct mode insert using the APPEND hint is a cool piece of technology that lets you load bulk data into

Continue reading

December 29, 2016 Uncategorized

Multi-table insert

An interesting question came through on AskTom recently.  The requirement was to perform a single pass through a source table,

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

    • 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
    • Why I blog
    • Implementing dynamic partitions AND subpartitions
    • How to generate random unique values
    • Is "fragmentation" still a dirty word?
    • INITRANS grabs a little more space
    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