Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Column masking in Oracle 10g
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 Received on Mon Jul 16 2007 - 22:27:56 CDT