AnsweredAssumed Answered

FastDataMasker Where clause syntax

Question asked by DivyaNori82351293 on Feb 28, 2018
Latest reply on Feb 28, 2018 by dovle01

Hi there,

 

Could you please help me with this?
I have been trying to mask a few rows using Fast data masker using the where clause. The issue is that when I run the masking, it errors out with "Error returned from Database:ORA-00933: SQL command not properly ended SQL"

 

These are the syntax I have tried but it still fails:
where clause: CUSTOMERNUMBER IN (1, 2, 3, 4, 5) is invalid

where clause:   CUSTOMERNUMBER IN (1, 2, 3, 4, 5) is invalid
where clause: CUSTOMERNUMBER = 1 is invalid

 

I am not sure if keyword 'IN' is supported or not, but '=' did not work either.

Am I following the incorrect syntax or am I missing anything here?

 

Thanks,

Divya N.

Outcomes