OraMatt: YABAOracle

Yet Another Blog About Oracle

Category: plsql

  • Using DBMS_REDEFINITION

    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…

  • Loading LOBs into a Table

    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…

  • Fun with Virtual Private Database

    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…

  • 12c Data Redaction (DBMS_REDACT ) Demo

    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…

  • Create Random Data & Bulk Insert from Nested Table

    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…

  • Bulk Collect speeds

    Quick example

Navigation

About

I’m Matt and I do Oracle things.