OraMatt: YABAOracle

Yet Another Blog About Oracle

Month: September 2013

  • 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…

  • Some 12c Multitenant commands

    Here are some useful commands I use when working with the new 12c Multitenant option. Open ALL Pluggable Databases (PDBs): As sysdba Switch to a PDB: Switch back the ROOT…

Navigation

About

I’m Matt and I do Oracle things.