I've got a backlog of Oracle stuffs to blog. In the words of my Data Structures professor at UW, "moer later."
Bind Variables: Not just for SELECTs!
Jonathan Lewis has a great piece on the importance of using bind variables in INSERT statements as well, avoiding expensive check constraint revalidation.
There is never, NEVER, N E V E R a reason to store passwords as clear text in a database. No matter how convenient it is for your own personal preference.Any aspiring application developers reading this: NEVER. Salt-n-hash is such an easy thing to do in most any language now,... [Read More]
Java5 Formatting Goodness
Back when I was researching how to format strings in java, I was dismayed that there wasn't built-in sprintf() functionality. There was a non-standard class written by some folks at Sun called PrintfFormat. Still, not the same.Yesterday I was reminded that such a thing was supposed to have been implemented... [Read More]
Monitor RMAN I/O
Yesterday in #oracle, hali pointed out the existance of the v$rman_backup_job_details view, and has since written a nice example post about using it to monitor the I/O done by every RMAN job you've done.