This is Part 3 of a series on madsql.Part 1 covered split-statements. Part 2 covered infer-schema. This post covers convert — the main migration command. By the time you reach convert in a migration workflow, you’ve already done two things:…
Database design is hard…seriously… If you need to modify a table after you’ve rolled it into production DBMS_REDEFINITION can really save you! Here’s a little example that shows taking a non-partitioned table and adding interval partitioning to it. Enjoy!
This is one of those topics that EVERYONE has a different take on and here’s mine! Using the LS_TABLE external table that you can find here you’ll be able to loop through all the files in a directory and load them into…
Virtual Private Database or VPD is one of those cool Oracle Database features that scare some folks because they think it’s SUPER HARD to setup and use. This little bit of demo code hopefully will dispel that … ENJOY! Create…
Oracle 12c introduced A TON of new features and options. One of the COOLEST (IMHO) is the Data Redaction packages. For those not in the know here’s what the Data Redaction Packages do: () Oracle Data Redaction enables you to…
Sometimes I need to create random datasets to explore how queries will run, so I whipped up this little sample procedure as a way to do it. This is basically just in case I forget… enjoy Create a quick test…
Quick example