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

December 13, 2021 Uncategorized

Detecting if your database is multitenant

Just a quick tip for this post today. I had a question come in asking how to detect whether a

Continue reading

October 31, 2019 Uncategorized

DML error logging – customising the error log table

I posted a nice little feature of DML error logging recently, and a comment came in mentioned that caution is

Continue reading

April 24, 2019 Uncategorized

Capture all DDL run on a database instance

I posted a video a couple of days ago showing a trigger mechanism to customize the capture of DDL that

Continue reading

October 20, 2016 Uncategorized

Taking a peek at SYS_CONTEXT

There was Twitter discussion about using context variables, accessed via SYS_CONTEXT within queries. It’s an easy means of passing parameters

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
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • Is "fragmentation" still a dirty word?
    • Implementing dynamic partitions AND subpartitions
    • When can I use SQL Macros?
    • INITRANS grabs a little more space
    • No more stale statistics in 19c
    • Some "must-have" ideas for your next meetup
    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