Well the datamasker demo pages show a simple exmple where a WHERE clause is used on the "gender" column to determine how the rule works on the "name" column. Not quite what your issue was but does show that the tools out there do have conditional logic in them so might still be worth a look.
Regards Tim Onions
I recently had the opportunity (successfully at that) to create such a manual script. I don't think that a 3rd party tool could have worked. Reason is that in _some_ of the tables, the ssn was in a column called
'>data' iff a column called 'name' was 'xyz' and there was numeric data
in cols 1 - 9 (or similar lack of logic).
_________________________________________________________________It's Hotmail's 10th Birthday! Come and play Pass the Parcel http://www.msnpasstheparcel.com
-- //www.freelists.org/webpage/oracle-l
