System Procedures Index
Procedures in SYS
- getXMLSchemas deprecated
Procedures in SYSADMIN
- addCliTemplate
- addRole
- addSystemProperty
- addUser
- addUserRole
- allowUserLogin
- batchUpdate
- changeCopyOverSourceTableJob
- changeUserPwd
- checkSortOrder
- cleanOrphanMatTableEntities
- cleanUpStaleMatTables
- createConnection
- createCreationParam
- createCopyOverSourceTableJob
- createDataSource
- createGatherStatisticsJob
- createIndex
- createOptimization
- createOptimizationQuery
- createSchedule
- createVirtualSchema
- deleteOptimization
- deleteRole
- deleteSchedule
- deleteSlackNotification
- deleteStatistics
- deleteSystemProperty
- deleteUser
- deleteUserRole
- deployModularConnector
- disableSlackNotification
- dropCliTemplate
- dropIndex
- dropIndexById
- dropIndexByName
- dropVirtualSchema
- editCliTemplate
- editCreationParam
- editSystemProperty
- enableOptimization
- enableSchedule
- enableSlackNotification
- execExternalProcess
- executeCli
- gatherStatistics
- getAllDataSourcesMetadataDiff
- getAuthMechanism
- getCatalogs
- getClientSecret
- getConnProp
- getCurrentVdb
- getDataCatalogAttribute
- getDataLineage
- getDataLineageRelationsOnly
- getDataSourceMetadataDiff
- getDefaultOptionValue
- getEncryptedUserPwd
- getGeneratedColumnNames
- getInstalledLicense
- getReplicatedTableDiff
- getResourceDependencies
- getSchemas
- getServerBuildInfo
- getServerVersion
- getSchemaTmpValue
- getTypeOfResource
- getViewAndProcCreationOrder
- gitCheckout
- gitClone
- gitCommit
- gitDeploy
- gitDiff
- gitExclude
- gitFixConflict
- gitInit
- gitPull
- gitPush
- gitSetRemote
- gitStatus
- gitTag
- hasPermission
- historyUpdate
- importConnection
- importDataSource
- importIndex
- importMatTable
- importOptimization
- importProcedure
- importRecOptSymbol
- importUser
- importView
- isLoggable
- getJwtToken
- killQuery
- leakyBucketReset
- leakyBucketTryConsume
- logMsg
- md5
- purgeObjects
- recreateConnection
- refreshAllDataSources
- refreshAllSchemas
- refreshDataSource
- refreshSchema
- refreshMatView deprecated
- refreshMatViewRow deprecated
- removeConnection
- removeDataCatalogAttribute
- removeDataSource
- renameRole
- renameUser
- renameVirtualSchema removed
- resetAtomicSchedule deprecated
- resetSchedule
- resetCliTemplates
- sendLicenseFile
- sendOracleADWCWallet deprecated
- setColumnStats
- setDataCatalogAttribute
- setDefaultOptionValue
- setOptimizationFrequency
- setPermissions
- setProperty
- setRemark
- setSchemaTmpValue
- setTableStats
- sleep
- testConnection
- translateColumnName
- translateColumnExpr
- UpdateSchedule
- webBusinessDataShopPublish
- webBusinessDataShopUnpublish
- writeConnProp
Procedures in SYSADMIN_VDB
Procedures in SYSLOG
- clearFinishedJobLogs
- clearHistory
- clearJobLogs
- clearPerformanceLogs
- clearQueryLogs
- getQueryLogPlan
- getQueryLogDataLineage
Procedures in UTILS
- arrayToTable
- cleanTable
- convertCSVtoTable
- createTable
- csvExport
- displayRuntime
- download_sftp
- formatTableName
- getModularConnectorDatasourceCreateStatement
- getSmtpConfiguration
- getTableIntersection
- importSmtpConfiguration
- incrementalReplication
- internal_expandProperties
- isBigQueryTable
- parsePropertiesString
- prepareTargetTable
- returnExtremeValue
- sendCsvExport
- sendMail
- setSmtpConfiguration
- tableExists
- tableToJson
- tableToXml
- tryCast
- tryCastDate
- tryCastTimestamp
- unzip
- upload_sftp
- upsert