Package com.oracle.bmc.databasemanagement.model

Class DropSqlsInSqlTuningSetDetails

java.lang.Object

com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

com.oracle.bmc.databasemanagement.model.DropSqlsInSqlTuningSetDetails

@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class DropSqlsInSqlTuningSetDetails
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

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
Note: Objects should always be created or deserialized using the DropSqlsInSqlTuningSetDetails.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the DropSqlsInSqlTuningSetDetails.Builder, which maintain a set of all explicitly set fields called DropSqlsInSqlTuningSetDetails.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	DropSqlsInSqlTuningSetDetails.Builder

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors

Constructor	Description
DropSqlsInSqlTuningSetDetails(SqlTuningSetAdminCredentialDetails credentialDetails, DatabaseCredentialDetails databaseCredential, Integer showSqlOnly, String owner, String name, String basicFilter)	Deprecated.

Method Summary

Modifier and Type	Method	Description
static DropSqlsInSqlTuningSetDetails.Builder	builder()	Create a new builder.
boolean	equals(Object o)
String	getBasicFilter()	Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW.
SqlTuningSetAdminCredentialDetails	getCredentialDetails()
DatabaseCredentialDetails	getDatabaseCredential()
String	getName()	The name of the Sql tuning set.
String	getOwner()	The owner of the Sql tuning set.
Integer	getShowSqlOnly()	Flag to indicate whether to drop the Sql statements or just display the plsql used to drop the Sql statements.
int	hashCode()
DropSqlsInSqlTuningSetDetails.Builder	toBuilder()
String	toString()
String	toString(boolean includeByteArrayContents)	Return a string representation of the object.

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

DropSqlsInSqlTuningSetDetails

@Deprecated
@ConstructorProperties({"credentialDetails","databaseCredential","showSqlOnly","owner","name","basicFilter"})
public DropSqlsInSqlTuningSetDetails(SqlTuningSetAdminCredentialDetails credentialDetails,
                                     DatabaseCredentialDetails databaseCredential,
                                     Integer showSqlOnly,
                                     String owner,
                                     String name,
                                     String basicFilter)

Deprecated.

Method Detail

builder

public static DropSqlsInSqlTuningSetDetails.Builder builder()

Create a new builder.

toBuilder

public DropSqlsInSqlTuningSetDetails.Builder toBuilder()

getCredentialDetails

public SqlTuningSetAdminCredentialDetails getCredentialDetails()

getDatabaseCredential

public DatabaseCredentialDetails getDatabaseCredential()

getShowSqlOnly

public Integer getShowSqlOnly()

Flag to indicate whether to drop the Sql statements or just display the plsql used to drop the Sql statements.

Returns:

the value

getOwner

public String getOwner()

The owner of the Sql tuning set.

Returns:

the value

getName

public String getName()

The name of the Sql tuning set.

Returns:

the value

getBasicFilter

public String getBasicFilter()

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

Returns:

the value

toString

public String toString()

Overrides:

toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

toString

public String toString(boolean includeByteArrayContents)

Return a string representation of the object.

Parameters:

includeByteArrayContents - true to include the full contents of byte arrays

Returns:

string representation

equals

public boolean equals(Object o)

Overrides:

equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

hashCode

public int hashCode()

Overrides:

hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel