November 2, 2000

Use printStackTrace() method to generate stack

Stack trace is a kind of call stack, which maintains the call sequence of methods at any given point in time. Throwable class in Java provides a method called “printStackTrace()” which can be used to print out the entire stack trace. You can use this method during debugging complex bug

Use Of ‘Connect By’ clause for Hierarchal Query

The Connect By clause is useful for tables which have 2 or more columns with parent-child relationships. While displaying rows, we can use ‘LEVEL’ pseudo column to indent the results as hierarchy.Consider the following example of a community table: Community_IdParent_IdCommunity_Nametmr>Select * from Communities;COMMUNITY_ID PARENT_ID COMMUNITY_NAME———— ———- ————————- 1 0 TV

Passing Objects in a Function

In Java, objects are passed to a function by reference, so you can manipulate the object data in the function and have that reflected outside the function also. If you try to swap the values of two object references inside a function, the values for the references inside the function

All the Changes, All the Time: Part I

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 this recurring issue by sharing some work I’ve recently completed for a client. This article assumes that you are familiar

Simplifying Date Data Entry with Calendars, Part I

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 birth for a sign-up form, or even a project’s beginning and ending dates for a more complicated form), you know

Paranoid and Proud of It: Planning Your Backups

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 some basic steps for risk mitigation in general. In this article I apply some professional paranoia to one of the

New PL/SQL Features in Oracle 8i: Part II

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 PL/SQL, Oracle’s procedural extension to industry-standard SQL. This article covers some of the other new features: bulk binds, autonomous transactions,