. . .you are absolutely correct, it is part of Oracle. We don't have it since we are still on Oracle 8i release 8.1.6.

In any case, the concept is great. One problem remains. Let me give you a better example which represents more clearly what I am trying to do.

Data Table - test_table
EmployeeID Last_Name First_Name Dept
12245 Jones Barry 001
14557 Green Frank 002
98774 Brown Tony 001
24557 Gilmore Dave 003

All employees in Dept = '001' must have encrypted employee ID.

CREATE VIEW test_v AS
SELECT Encrypted( EmployeeID ), Last_name, First_Name,
Dept
FROM test_table;

If I issue a SELECT * FROM test_v, it works just fine.
The problem is if I say:

SELECT * FROM test_v
WHERE EmployeeID IN ('12245', '14557', '98774', '24557');
This will probably not work, since the view encrypts the EmployeeID field and the WHERE clause will not be able to match up the items in the IN list.

What do you think?