Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace 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

Properties

Functions

Properties

Optional basicFilter

basicFilter: undefined | 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

Optional credentialDetails

credentialDetails: SqlTuningSetAdminPasswordCredentialDetails | SqlTuningSetAdminSecretCredentialDetails

Optional databaseCredential

databaseCredential: DatabaseSecretCredentialDetails | DatabaseNamedCredentialDetails | DatabasePasswordCredentialDetails

name

name: string

The name of the Sql tuning set.

Optional owner

owner: undefined | string

The owner of the Sql tuning set.

Optional showSqlOnly

showSqlOnly: undefined | number

Flag to indicate whether to drop the Sql statements or just display the plsql used to drop the Sql statements. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

getJsonObj