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
Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL
The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card
In 12c, we introduced a feature call Row Archival, which is a means of integrating typical archival models that we
Full disclosure: This is a rant post. If you’re not into ranting and pontificating, perhaps best to move along now
One of the cool things to come out of the partitioning option many moons ago was the feature known as
Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and
Handling default values on columns has been an age old problem that we solved in 12c with extensions to the
I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get
Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means
The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve