ddl – Learning is not a spectator sport

DDL invalidates your SQL right ?

I stumbled upon this post by optimizer guru Nigel Bayliss last week, so please have a read of that first

This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by

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

The DBMS_METADATA package is very cool. I remember the days of either hand-crafting DDL statements based on queries to the

SQL loader is a very cool utility that has existed for a long time within Oracle to load flat files

This one caught me out – I was racing around looking for bugs, or parameter files, or hidden settings that

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

I’ve always been worried about taking a script that is fine to run in my non-production environments (in particular a

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

Here’s a very simple example of a table called PARENT being a (surprise surprise) parent in a referential integrity relationship