• 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!
April 24, 2014 Uncategorized

Really dumb triggers

Some people hate triggers, some people love triggers… I am not that opinionated on them in either direction, but one

Continue reading

April 12, 2014 Uncategorized

An accusatory error message

I found this hilarious SQL> startup ORACLE instance started. Total System Global Area 1469792256 bytes Fixed Size 2402776 bytes Variable

Continue reading

April 12, 2014 Uncategorized

SQL injection

Another big public username and password leak… http://o.canada.com/technology/bell-canada-security-breach-391451/ Some good reading on how it was done, and thus ensuring your

Continue reading

April 12, 2014 Uncategorized

Pluggable database and restricted sessions

Once you get into pluggable database territory, you might need to check your usage of “alter system enable restricted session”,

Continue reading

April 12, 2014 Uncategorized

OUGN 2014

I had the pleasure of being a guest of the Norwegian User Group for the second year in a row

Continue reading

March 28, 2014 Uncategorized

Norway bound

I cant wait to get to Norway again for this year’s OUGN conference. If you’re in Europe…this should be on

Continue reading

March 13, 2014 Uncategorized

views in 12c

Observed an interesting idiosyncracy in the creation of views in 12c (this is in a pluggable database, but not confirmed

Continue reading

February 20, 2014 Uncategorized

Oracle Developer Day Perth

Well…it was a great day with over 100 people attending. I had the standard fail of trying to show people

Continue reading

January 20, 2014 Uncategorized

Free developer day in Perth

Got a massive day of goodies coming to anyone in Perth..for absolutely no cost – just your time and your

Continue reading

January 18, 2014 Uncategorized

ORA-65131 grrrr

So…the future is container databases ? Cool ! I’ll create all my databases as container databases….I’m so happy….until SQL> CREATE

Continue reading

Posts navigation

«Previous Posts 1 … 62 63 64 65 66 … 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...