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

August 6, 2021 Uncategorized

We killed sequence contention!

A few months back I gave a talk on the importance of good physical design if you need to meet

Continue reading

July 10, 2020 Uncategorized

How to generate random unique values

When sequences won’t do In an Oracle database if someone comes to you and says “I need to generate unique

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

December 3, 2018 Uncategorized

Automatic sequences not being dropped

One of the nice new things in 12c was the concept of identity columns. In terms of the functionality they

Continue reading

January 24, 2018 Uncategorized

Identity columns in 12c … just a sequence ?

This question came to me over Twitter, so I thought I’d whip out a quick post on it   Yes,

Continue reading

May 2, 2017 Uncategorized

Quick tip–identity columns

Lets say I’ve been reading about schema separation, and thus I am going to have a schema which owns all

Continue reading

May 27, 2016 Uncategorized

Let me START WITH sequences

It’s always cool that you can learn stuff every single day, even on the most simple of topics.  This one

Continue reading

February 23, 2016 Uncategorized

Something new learned every day

One of the reasons I leapt at the chance to be on the AskTom team when we resurrected the site,

Continue reading

February 18, 2016 Uncategorized

DEFAULT SEQ.NEXTVAL in 12c

One of the cool things in 12c is that (finally after all these years) a sequence can be assigned as

Continue reading

November 16, 2015 Uncategorized

You dont need that sequence number

I’ve lost track of the number of times I see this sequence (no pun intended) of actions in code: SELECT

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
    • Why I blog
    • How to do a GRANT on an entire schema
    • Implementing dynamic partitions AND subpartitions
    • How to generate random unique values
    • How to TREAT data in a CLOB as JSON
    • Is "fragmentation" still a dirty word?
    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