triggers – Learning is not a spectator sport

Grab all the DDL

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

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

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

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

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

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

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

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

If you create a trigger that does not compile, any part of your application that refers to the table with

In the previous post, I pontificated about triggers that “lock you in” to having them fire, which can create dramas