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
he task of retrieving the top or bottom N rows from a database table (by salary, sales amount, credit, etc.) is often referred to as a “top-N query.” This task
n last month’s article I showed you how to create a calendar page in ASP with pop-up functionality. In this month’s article, I’ll show you how to make your pop-up
n my series of articles, “Paranoid and Proud of It,” I pointed out that systems require different backup strategies, depending on the criticality of the information stored in them. SQL
n my first article on this subject, I discussed the need to have a healthy dose of paranoia when planning how to protect your systems and information. I also demonstrated
here are numerous reasons why building data entry forms can cause an ASP developer headaches. If you are building a form that captures a date (for example, a date of
his 10-Minute Solution was prompted by a question to the Ask the SQL Pro site regarding how best to capture changes that have occurred in a database. I will address
n my last article, “New PL/SQL Features in Oracle 8i: Part I“, I described some of the new features in Oracle 8i that extend the power, performance, and flexibility of
L/SQL is Oracle’s procedural extension to industry-standard SQL. Prior to Oracle 8i, PL/SQL was in a sort of static condition. It has not been changed much since Oracle 7. I