• 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!
September 11, 2013 Uncategorized

12c FETCH FIRST

Tom Kyte’s latest magazine article talks about the new FETCH FIRST syntax in 12c. You can read about that at:

Continue reading

September 3, 2013 Uncategorized

Insync 13 Brisbane

Just a quick note to let you know I’ll upload the slides in the next few days

August 31, 2013 Uncategorized

30 chars just not enough…

Sometimes even Oracle itself just can’t cope with the 30 character limit This from a M000 trace file 🙂 ***

Continue reading

August 26, 2013 Uncategorized

Compressed partitions are not compressed tables

So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then

Continue reading

July 26, 2013 Uncategorized

How big will my index be ?

You’ve got a big table…you want to add an index. Will you have enough space ? Well, its not perfect

Continue reading

July 22, 2013 Uncategorized

12c invisible columns

As several bloggers have already pointed out, column order changes when you start playing with invisible columns, for example SQL>

Continue reading

July 13, 2013 Uncategorized

12c ddl logging

In new releases, its often the little things that really catch my attention. Like this one…. I love it SQL>

Continue reading

July 12, 2013 Uncategorized

12c install on Windows

This is not a complete how-to, because I do not think its warranted…you pretty much click Next Next Next (which

Continue reading

July 9, 2013 Uncategorized

from a friend…

A friend was recently describing Agile to me…I stress, not Agile the principle, but Agile the way its been implemented

Continue reading

July 1, 2013 Uncategorized

Feeling raw about raw…

Its been well documented for a while that Oracle were not going to allow raw devices in 12….but this still

Continue reading

Posts navigation

«Previous Posts 1 … 64 65 66 67 68 … 73 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

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Digging deeper into SQL under APEX
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 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...