Yet Another Blog About Oracle
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…
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…
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…
I’m a big fan of Edition-Based Redefinition that was introduced in Oracle Database 11gR2. Edition-based redefinition enables you to upgrade the database component of an application while it is in…
Quick example
I’m Matt and I do Oracle things.