From time to time you’ll have to represent your data stored in a database in an XML format, eg. to exchange it between systems, to send it to external parties, etc.
In an article on All Things Oracle I give an introduction on how you can generate XML documents:
Another interesting article from my colleague Jan Leers is about Code Instrumentation.
Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to do, but what if it doesn’t?
What if it takes a lot more time then expected?
All kind of questions start to arise:
- Is it almost finished, should I wait just a few more minutes?
- Is it trapped in an infinitive loop? Or are my queries running slow?
- Can I safely kill it? Or did it already commit some changes and should I reverse them?
- Which job should I kill, is this mine?
Want to find out how you can answer these questions? Read his article on All Things Oracle…