• 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!
June 30, 2013 Uncategorized

Expunging the Expand all

I’m sure many people love the collapsed form of the Oracle documentation, with the associated “Expand All” function… Me….I hate

Continue reading

June 23, 2013 Uncategorized

Even on an ocean liner…

…. Perth still looks good 🙂

June 22, 2013 Uncategorized

A little quiz on tkprof

I found this in a trace file recently INSERT INTO T (X) VALUES(:B1) call count cpu elapsed disk query current

Continue reading

June 8, 2013 Uncategorized

can you lock part of a table ?

I should stress that this is all well covered in the documentation, but it was something I stumbled upon just

Continue reading

June 8, 2013 Uncategorized

hash keys … almost unique

In the Oracle documentation, the specification for ORA_HASH is: The optional max_bucket argument determines the maximum bucket value returned by

Continue reading

May 14, 2013 Uncategorized

Datatype discipline

(This is based on some ‘issues’ a client was having, so the example is architected to make a particular point,

Continue reading

May 13, 2013 Uncategorized

Default null for collection parameter

I’ve got an existing package called DEMO as below SQL> create or replace package demo is 2 — used to

Continue reading

May 1, 2013 Uncategorized

Long overdue…

The OTN forums, which should be a plethora of knowledge and learning, were always hampered by the hideous interface. But,

Continue reading

April 29, 2013 Uncategorized

Its not about the outage

My Oracle Support had a fairly lengthy outage today right in the middle of the Australian business day. But I’m

Continue reading

April 29, 2013 Uncategorized

OUGN Norway Conference

The OUGN conference (held on a cruise ship) was an awesome experience and so professionally run by the committee.  I

Continue reading

Posts navigation

«Previous Posts 1 … 65 66 67 68 69 … 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
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    • Digging deeper into SQL under APEX
    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...