I've just read a whole bunch about Test Driven Design, automated unit
testing, xUnit, JUnit, Quest's code testing tool (at $595 a pop, or some
such....eek!) , utPLSQL, pl/unit, and PLUTO. Whew!
Has anyone had any experience with any of the above, either the TDD idea

I have a production system with "i" stages (i is a small number, 5 or 6
tops)
At each moment in time there are N(i) items in progress at stage i.
Lets say I sample the number of items in progress at each stage once

Is there any way to determine the NLS_LANG of a client using SQL or PL/SQL.
sys_context('USERENV','LANGUAGE') gives the database characterset, not the clients.
Thanks,
Gerard

We have a huge table (approx ~300 million rows) with ~150 columns in
the table.
This table is partioned in 8 partitions.
We need to extract one file per partition.

Here's my dilemma:
* Love TOAD. Been using TOAD 7.x. Recently upgraded to 10g servers
with 11g clients and TOAD no longer works. The latest TOAD will work
(9.x), but our budget got slashed so no purchase.

Designer Version is 10.1.2.0.2.
Whenever I generate the schema/ddl creation scripts after making minor
changes, I like to compare the new scripts against the last set just to
make sure the changes are as I expect. The trouble is each time I

What's the best way in APEX to handle self-registration of members and
then using that info for subsequent member login. There'd be a table like:
MEMBERS:
MEMBER_ID   VARCHAR2(10)