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

December 16, 2019 Uncategorized

Listener log data mining with SQL

If you take a look at the log files created by the listener, there is obviously a nice wealth of

Continue reading

September 9, 2019 Uncategorized

Extending in-lists past the 1000 item barrier

A well known “limitation” of Oracle is that you can only have 1000 elements within an IN-LIST style expression in

Continue reading

January 23, 2018 Uncategorized

Subtle changes in XML, 11g vs 12c

An AskTOM reader brought this to our attention.  It is unlikely to cause you any issues, but perhaps is good

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

    • SQL engine and PL/SQL functions
    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • No more stale statistics in 19c
    • A new use for DML error logging
    • How to TREAT data in a CLOB as JSON
    • How to generate random unique values
    • Getting a dog improved my productivity
    • Automatically generate audit capture for tables
    • Archives
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 846 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