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.

Inheritance

object

FormatEntry

SQLExpressionFormatEntry

Inherited Members

FormatEntry.Description

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

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