Class SqlText

SQL Text type object.

Inheritance

object

SqlText

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.OpsiService.Models

Assembly: OCI.DotNetSDK.Opsi.dll

Syntax

public class SqlText

Properties

ExactMatchingSignature

Declaration

[JsonProperty(PropertyName = "exactMatchingSignature")]
public string ExactMatchingSignature { get; set; }

Property Value

Type	Description
string	Exact matching signature Example: "18067345456756876713"

ForceMatchingSignature

Declaration

[JsonProperty(PropertyName = "forceMatchingSignature")]
public string ForceMatchingSignature { get; set; }

Property Value

Type	Description
string	Force matching signature Example: "18067345456756876713"

SqlCommand

Declaration

[Required(ErrorMessage = "SqlCommand is required.")]
[JsonProperty(PropertyName = "sqlCommand")]
public string SqlCommand { get; set; }

Property Value

Type	Description
string	SQL command Example: "SELECT"

Remarks

Required

SqlFullText

Declaration

[Required(ErrorMessage = "SqlFullText is required.")]
[JsonProperty(PropertyName = "sqlFullText")]
public string SqlFullText { get; set; }

Property Value

Type	Description
string	Full SQL Text Example: "SELECT username,profile,default_tablespace,temporary_tablespace FROM dba_users"Disclaimer: SQL text being uploaded explicitly via APIs is not masked. Any sensitive literals contained in the sqlFullText column should be masked prior to ingestion.

Remarks

Required

SqlIdentifier

Declaration

[Required(ErrorMessage = "SqlIdentifier is required.")]
[JsonProperty(PropertyName = "sqlIdentifier")]
public string SqlIdentifier { get; set; }

Property Value

Type	Description
string	Unique SQL_ID for a SQL Statement.

Remarks

Required

TimeCollected

Declaration

[Required(ErrorMessage = "TimeCollected is required.")]
[JsonProperty(PropertyName = "timeCollected")]
public DateTime? TimeCollected { get; set; }

Property Value

Type	Description
DateTime?	Collection timestamp Example: "2020-05-06T00:00:00.000Z"

Remarks

Required

Version

Declaration

[JsonProperty(PropertyName = "version")]
public float? Version { get; set; }

Property Value

Type	Description
float?	Version Example: 1