8 Replies Latest reply: Aug 5, 2014 9:12 AM by rp0428 RSS

    DML on Oracle Redact Data Mask

    2678191

      Hi,

      How to use where clause on masked attribute

       

      for example


      select * from FLX_DD_STMT_GEN_ITEMS where DEBIT_CARD_NO is not null

      401795XXXXXX9206 (masked column)

       

      Can I say like select * from FLX_DD_STMT_GEN_ITEMS where debit_card_no = ‘4017959999999206’

       

      Can I use the real value in where clause?

       

      Thanks