In Microsoft SQL Server, we write below ALTER statement to mask a particular column:
ALTER TABLE [Table_Name]
ALTER COLUMN YEAR_CODE ADD MASKED WITH (FUNCTION = 'default()');
Currently I am working on Oracle and trying the replicate the same in Oracle to mask a column.
In Oracle SQL Developer the above command is giving the error as:
Error report -
ORA-01735: invalid ALTER TABLE option
01735. 00000 - "invalid ALTER TABLE option"
*Cause:
*Action:
Whereas I expect Success message in Output window of Oracle. Can anybody help me to convert the above statement in Oracle as this statement does not work on Oracle SQL Developer.