Class DropSqlsInSqlTuningSetDetails

Drops the selected list of Sql statements from the current Sql tuning set. The basicFilter parameter specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. If a valid filter criteria is specified, then, Sql statements matching this filter criteria will be deleted from the current Sql tuning set. If filter criteria is not specified, then, all Sql statements will be deleted from the current Sql tuning set. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential

Inheritance

object

DropSqlsInSqlTuningSetDetails

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class DropSqlsInSqlTuningSetDetails

Properties

BasicFilter

Declaration

[JsonProperty(PropertyName = "basicFilter")]
public string BasicFilter { get; set; }

Property Value

Type	Description
string	Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. User could use any combination of the following columns with appropriate values as Sql predicate Refer to the documentation https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SQLTUNE.html#GUID-1F4AFB03-7B29-46FC-B3F2-CB01EC36326C

CredentialDetails

Declaration

[JsonProperty(PropertyName = "credentialDetails")]
public SqlTuningSetAdminCredentialDetails CredentialDetails { get; set; }

Property Value

Type	Description
SqlTuningSetAdminCredentialDetails

DatabaseCredential

Declaration

[JsonProperty(PropertyName = "databaseCredential")]
public DatabaseCredentialDetails DatabaseCredential { get; set; }

Property Value

Type	Description
DatabaseCredentialDetails

Name

Declaration

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

Property Value

Type	Description
string	The name of the Sql tuning set.

Remarks

Required

Owner

Declaration

[JsonProperty(PropertyName = "owner")]
public string Owner { get; set; }

Property Value

Type	Description
string	The owner of the Sql tuning set.

ShowSqlOnly

Declaration

[JsonProperty(PropertyName = "showSqlOnly")]
public int? ShowSqlOnly { get; set; }

Property Value

Type	Description
int?	Flag to indicate whether to drop the Sql statements or just display the plsql used to drop the Sql statements.