Class SQLExpressionFormatEntry
The SQL Expression masking format uses a SQL expression to generate values that are used to replace the original data values. SQL expressions with dbms_lob and other user-defined functions can be used to mask columns of Large Object data type (LOB). To learn more, check SQL Expression in the Data Safe documentation.
Inherited Members
Namespace: Oci.DatasafeService.Models
Assembly: OCI.DotNetSDK.Datasafe.dll
Syntax
public class SQLExpressionFormatEntry : FormatEntry
Properties
SqlExpression
Declaration
[Required(ErrorMessage = "SqlExpression is required.")]
[JsonProperty(PropertyName = "sqlExpression")]
public string SqlExpression { get; set; }
Property Value
Type | Description |
---|---|
string | The SQL expression to be used to generate the masked values. It can consist of one or more values, operators, and SQL functions that evaluate to a value. It can also contain substitution columns from the same table. Specify the substitution columns within percent (%) symbols. |
Remarks
Required