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

an old style wooden ruler with measurements from 1 to 10centimeter
May 12, 2022 Uncategorized

The Fractional Part of a TIMESTAMP. Be careful.

This discovery came in from an AskTom customer but I figured it’s worth passing on to any PL/SQL programmers out

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

a female police officer standing guard
March 30, 2022 Uncategorized

Enforcing DEFAULT values

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

Continue reading

a christmas tree
December 20, 2021 Uncategorized

Christmas SQL

Just a re-post of something I put on StackOverflow last year so I can refer back to it easily. What

Continue reading

December 13, 2021 Uncategorized

Detecting if your database is multitenant

Just a quick tip for this post today. I had a question come in asking how to detect whether a

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

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

October 4, 2021 Uncategorized

Get the SQL_ID for a SQL statement BEFORE you run it

An AskTom customer asked the question recently: “We often use the SQL_ID to dig into the performance views once we

Continue reading

Posts navigation

1 2 3 … 12 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
  • Version 7 was so much better...
  • The Fractional Part of a TIMESTAMP. Be careful.
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to TREAT data in a CLOB as JSON
  • Connection shortcuts with a wallet
  • A little known RI clause
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • MERGE and ORA-30926
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 810 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...