The Final Tip is Coming Soon

All, Sorry about the cliffhanger on the final tip of my five part series; the Windows installation my DB was on crashed, and I have to recover the OS so I can get the database back up and running. ...

Trick #4 – Pull XML with DBMS_XMLGEN

This entry is part 4 of 5 in the series 5 Little Known Oracle Tricks Wouldn’t it be fantastic if you could simply pull data from the database in XML? Many shops use XML for data transfer, web...

Trick #3 – Store Any Data with AnyData

This entry is part 3 of 5 in the series 5 Little Known Oracle Tricks Today’s (well, yesterday’s really) trick deals with the storage of data. Let me first say that the methods I’m about...

Oracle Tricks – Many Apologies

It seems I’ve run out of time in the day…I had hoped to provide an article today on Trick #3, yet work has piled up and I was not able to get it done. Rest assured, despite my previous article,...

New Toy! The 80GB iPod

I had made a post about the 80GB iPod, how much I loved it, and how great it was, and now suddenly it’s deleted. Ah well, c’est la vie, no? Anyways, I don’t remember everything that was...

Trick #2 – Rewrite a Query at Runtime

This entry is part 2 of 5 in the series 5 Little Known Oracle Tricks There are many Oracle tools that can wreak havoc on an unsuspecting DBA or developer, but all in all they are for the common good. ...