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

two identical sheep
March 7, 2022 Uncategorized

After you clone your pluggable database

Recently I cloned one my (pluggable) databases to a throwaway copy so that I could do some testing of an

Continue reading

August 4, 2020 Uncategorized

Automatically generate audit capture for tables

A weekend audit Often if you see the words “weekend audit” in a non-technical sense, it means that awkward moment

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

June 26, 2018 Uncategorized

More triggers are better

Yes, you heard me correctly. If you have got one trigger on a table, then you might be surprised to

Continue reading

June 20, 2018 Uncategorized

When WHEN went faster

Yeah…try saying that blog post title 10 times in a row as fast as you can But since we’re talking

Continue reading

January 25, 2018 Uncategorized

Those pesky LONG columns

There was a time, many moons ago when CLOB, BLOB and BFILE did not exist as data types. So if

Continue reading

January 24, 2018 Uncategorized

Identity columns in 12c … just a sequence ?

This question came to me over Twitter, so I thought I’d whip out a quick post on it   Yes,

Continue reading

February 24, 2017 Uncategorized

DDL triggers – interesting results

This question came in on AskTom, yielding a very interesting result when it comes to DDL triggers. To set the

Continue reading

March 2, 2016 Uncategorized

FOLLOWS clause

In early Oracle releases, you could have 1 trigger per type of trigger per table (eg if you had a

Continue reading

November 27, 2015 Uncategorized

Where did my triggers go ?

You need to be careful when coding and using triggers when it comes to Datapump (or anything that transposes triggers

Continue reading

Posts navigation

1 2 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

  • Powerpoint hack for tech presenters
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to do a GRANT on an entire schema
  • Juice up your JSON on Autonomous
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • Digging deeper into SQL under APEX
  • Don't run tight on PGA
  • The death of UTL_FILE
  • UTL_CALL_STACK lends a helping hand to DBMS_UTILITY
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 821 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...