Re: Column masking in Oracle 10g

query wrote:
> hi,
>
> If i use the column masking policy of Virtual Database Policy(VPD ) in
> Oracle 10g to mask one column in the table, can i use this column in
> the join conditions?
>
> eg:
> Table T1 has coloumns a1 and b1.
> Table T2 has columns a2 and b2.
> the a1 column in the table T1 is masked.
>
> select b1 from T1,T2 where a1=a2;
>
> is this possible???
>
>
> thankz

No ... create a view with instead-of triggers

http://www.psoug.org/reference/instead_of_trigger.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org