• 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!
August 20, 2015 Uncategorized

Where is my tracefile

As a developer, you might have have been reading about SQL trace. After all, we all want to be able

Continue reading

August 17, 2015 Uncategorized

Loading file data … easier than you think

So a request comes in from a colleague… ”Hi Connor.  I’ve created this new table, and I need to populate

Continue reading

August 15, 2015 Uncategorized

Mr DISTINCT might not be your friend

Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure

Continue reading

August 10, 2015 Uncategorized

Better SQL via query block names

Can you make your SQL code easier to understand without adding comments. Can it be self-documenting ? Can you do

Continue reading

August 5, 2015 Uncategorized

Index compression–working out the compression number

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives

Continue reading

August 5, 2015 Uncategorized

Navigating the world of Oracle database documentation

If you head on over to http://docs.oracle.com/en/database/ you’ll be both amazed and dismayed by the volume of documentation you can

Continue reading

July 31, 2015 Uncategorized

Joining Oracle

Last month I joined Oracle after nearly 20 years of working with their technology.  Some people congratulated me on my

Continue reading

July 27, 2015 Uncategorized

Things that are there but you cannot use

I did a “desc” command on the STANDARD package today, the package that helps define PL/SQL, and saw the XOR

Continue reading

July 3, 2015 Uncategorized

Continuous Delivery – Moving to SECUREFILE

You’ve been google-ing and you’ve seen articles (for example) like http://www.oracle.com/technetwork/articles/sql/11g-securefiles-084075.html and you’re pretty pumped about using SECUREFILE features. You’ve

Continue reading

July 3, 2015 Uncategorized

Continuous delivery…

“Continuous Delivery (CD) is a software engineering approach in which teams keep producing valuable software in short cycles and ensure

Continue reading

Posts navigation

«Previous Posts 1 … 58 59 60 61 62 … 74 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
    • Why I blog
    • Implementing dynamic partitions AND subpartitions
    • How to TREAT data in a CLOB as JSON
    • 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
     

    Loading Comments...