I thought I knew bulk operations well. Today, while coding up a quick hunk of PL/SQL, the code did not behave as expected. Basically, I’d had a senior moment and forgotten something that I think my novice DBA and developer readers might benefit from. When you try to select some rows from a data structure…
Month: October 2016
Dropping a View Drops the Instead-of Triggers
On top of using this blog to speak on data and database design and development, I’ll also be using it as a notebook, documenting the moments of discovery and clarity that occur when dealing with problems. I wish I’d been taking notes this way since I began my career in 1995, instead of just hoping…