devxlogo

Get Help

Document Your XSLT

“Document Your Code! Document Your Code!!” This is one of those lessons hammered into most Computer Science majors about three days into their first code class–and one quickly forgotten by

Cloning Data Accurately and Randomly

ecently I encountered a couple of Oracle-tuning projects that required me to evaluate the performance of PL/SQL and SQL code. I had to generate a substantial amount of data from

Understanding and Calculating Dates

QL Server provides many sophisticated functions to calculate dates. But knowing how to use them can often be a challenge. Suppose you want to calculate when a package is due

Creating Clickable Appointments

onsider the scenario in which you are building a Web application that displays events or appointments for different dates. If you want your users to remember this event within their

Creating a “Complete” Backup Solution

ne of the inherent difficulties in backup and contingency planning is that it usually takes only one thing to go wrong to bring down your entire system. To be truly

Profiling in Oracle 8i

n a previous 10-Minute Solution, “New PL/SQL Features in Oracle 8i: Part I,” I write that Oracle PL/SQL programmers develop complex code nowadays, utilizing custom and Oracle-supplied packages. It therefore