• 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!
a picture from the rear of a mclaren sports car
December 6, 2021 Uncategorized

SQL*Plus shortcut for fast data unload

I published a video a few days ago on the various tools you can use to unload data out of

Continue reading

a front on picture of an alpaca chewing on grass
November 29, 2021 Uncategorized

The Importance Of Testing

In last weeks’ Office Hours session, I posted an “impossible” challenge to two of the most well credentialed Oracle community

Continue reading

November 22, 2021 Uncategorized

Testing versus the Database

A phrase I’ve often used when discussing database design is “insurance policy”, namely, when I talk about adding CHECK constraints,

Continue reading

a picture of fish oil tablets spilling from a vitamin container
November 16, 2021 Uncategorized

SQL Macros – complex SQL made easy. Elapsed time calculation

The more you play with SQL macros, the more you find simple but powerful use cases which will make life

Continue reading

congested traffic across 4 lanes
November 14, 2021 Uncategorized

The big table dilemma – what about transaction rates?

Yesterday I posted some demonstrations of the impressive power of indexes in relational databases for data retrieval even when those

Continue reading

a truck overfilled with cut logs driving on the highway
November 13, 2021 Uncategorized

When does a table become too big?

I happened across an interesting thread on Twitter today which posed the question about when you should intervene with alternative

Continue reading

November 12, 2021 Uncategorized

Formula 1 data–staying up to date

Just an addenda to what I posted last week about downloading the Formula 1 motor racing data where I provided

Continue reading

November 8, 2021 Uncategorized

Database World 2021 – now it is your turn

Thanks for attending my talk on Futuristic SQL during Database World.If you missed it, or want to rewatch it at

Continue reading

November 5, 2021 Uncategorized

APEX demos – Formula 1 Racing Data ?

Naturally there was an overwhelming urge to title this post “The Need for Speed” and sprinkle Maverick and Goose references

Continue reading

November 2, 2021 Uncategorized

Quick and easy sample data

If you head over to the official database sample schema github repo you’ll find all the standard schemas that you’ll

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 5 6 … 70 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.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Why you keep getting "ORA-01653: unable to extend table"
  • Extending in-lists past the 1000 item barrier
  • Connection shortcuts with a wallet
  • How to TREAT data in a CLOB as JSON
  • No more stale statistics in 19c
  • Generating INSERT scripts that run fast!
  • Automatically generate audit capture for tables
  • Complex materialized views and fast refresh
  • Free In-memory in Oracle Database 19c
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 814 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...