ddl – Learning is not a spectator sport

Comparing two database objects for differences

Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL

Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and

Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our

There are plenty of tools out there that you can use to get DDL scripts for various objects in the

I was helping out a customer today with what they thought was a bug in DBMS_METADATA. They were using it

First things first. If you are not familiar with the term “gets my goat” then you can find a definition

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