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. That’s why I just love the Mac. 😉 There will be
Month: September 2006
Trick #4 – Pull XML with DBMS_XMLGEN
Wouldn’t it be fantastic if you could simply pull data from the database in XML? Many shops use XML for data transfer, web services, reports, and more. Oracle’s XML Publisher product can retrieve XML from an HTTP feed and use it to generate rich reports with graphs, images, and other
Trick #3 – Store Any Data with AnyData
Today’s (well, yesterday’s really) trick deals with the storage of data. Let me first say that the methods I’m about to show you are NOT useful for where clauses or in normal database design. However, they can be very useful when you need a reference table that can store anything
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, that I did not spend all day playing with my
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 there, but suffice it to say that the iPod is amazing. You can
Trick #2 – Rewrite a Query at Runtime
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. Though Oracle never puts procedures in place that are made for practical jokes, the DBMS_ADVANCED_REWRITE package comes close. DBMS_ADVANCED_REWRITE allows you to transform queries on
Trick #1 – Copying Users the Right Way
Yesterday I announced that I would be doing a five day series entitled “The 5 Oracle Tricks You Never Knew.” Today’s trick is pretty simple, and it allows you to copy user accounts from one instance to another with the same password, grants, roles, etc, without using the exp/imp tools.
The 5 Oracle Tricks You Never Knew
Hello all! Over the next few days I’ll be updating my blog with 5 Oracle tricks that you may not even know about. They’re all pretty neat, and actually useful to a DBA (one of them is even useful for practical jokes)! These tips will be presented daily in the
I am finally back!
It has been quite a while since I made a post, but things have been extremely hectic! I took a road trip with my wife and two kids to Oklahoma City from Virginia Beach…this was a three day drive for us, as kids always slow you down as well as