Using Supplied Packages to Manage Stored Outlines
The DBMS_OUTLN and DBMS_OUTLN_EDIT package provides procedures used for
managing stored outlines and their outline categories.
Users need the EXECUTE_CATALOG_ROLE role to execute DBMS_OUTLN, but public
has execute privileges on DBMS_OUTLN_EDIT. The DBMS_OUTLN_EDIT package is an
invoker's rights package.
Some of the useful DBMS_OUTLN and DBMS_OUTLN_EDIT procedures are:
■ CLEAR_USED - Clears specified outline
■ DROP_BY_CAT - Drops outlines that belong to a specified category
■ UPDATE_BY_CAT - Changes the category of outlines in one specified category to
a new specified category
■ EXACT_TEXT_SIGNATURES - Computes an outline signature according to an
exact text matching scheme
■ GENERATE_SIGNATURE - Generates a signature for the specified SQL text[@more@]
managing stored outlines and their outline categories.
Users need the EXECUTE_CATALOG_ROLE role to execute DBMS_OUTLN, but public
has execute privileges on DBMS_OUTLN_EDIT. The DBMS_OUTLN_EDIT package is an
invoker's rights package.
Some of the useful DBMS_OUTLN and DBMS_OUTLN_EDIT procedures are:
■ CLEAR_USED - Clears specified outline
■ DROP_BY_CAT - Drops outlines that belong to a specified category
■ UPDATE_BY_CAT - Changes the category of outlines in one specified category to
a new specified category
■ EXACT_TEXT_SIGNATURES - Computes an outline signature according to an
exact text matching scheme
■ GENERATE_SIGNATURE - Generates a signature for the specified SQL text[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1007355/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- python modules and packagesPythonPackage
- stored procedure 收集session wait 資訊(轉)SessionAI
- iOS解決CUICatalog: Invalid asset name supplied問題iOSUI
- manage-docs-versions
- MySQL 索引優化 Using where, Using filesortMySql索引優化
- 每日一個 Golang PackagesGolangPackage
- Spring 呼叫 Stored Procedure 並獲取返回值Spring
- MySQL explain結果Extra中"Using Index"與"Using where; Using index"區別MySqlAIIndex
- Unofficial Windows Binaries for Python Extension PackagesWindowsPythonPackage
- Using hints for PostgresqlSQL
- String interpolation using $
- using的用法
- Using mysqldump for backupsMySql
- MySQL 之 USINGMySql
- npm publish gives “unscoped packages cannot be private”NPMPackage
- Manage SQL Plan Baselines in Oracle 12cSQLOracle
- SAP Fiori 應用 Manage Workflows for Purchase RequisitionsUI
- Orale的struct,array,cursor,stored procedure,function,package的用法例子StructFunctionPackage
- pdf crop using pythonPython
- MGTSC 212 using ExcelExcel
- Video Division with using OpenCvIDEOpenCV
- Dictionary application using SwingAPP
- What are the benefits of using an proxy?
- 淺談Using filesort和Using temporary 為什麼這麼慢
- Vue packages version conflicts 錯誤修復VuePackage
- 每日一個 Golang Packages 06/11 syncGolangPackage
- 每日一個 Golang Packages 06/10 runtimeGolangPackage
- 每日一個 Golang Packages 06/04 timeGolangPackage
- 每日一個 Golang Packages 06/05 stringsGolangPackage
- 每日一個 Golang Packages 06/09 mathGolangPackage
- pip install 提示:Could not install packages due to an EnvironmentErrorPackageError
- 每日一個 Golang Packages 06/12 fmtGolangPackage
- lerna管理前端packages的最佳實踐前端Package
- dart系列之:在dart中使用packagesDartPackage
- How to prevent your jar packages from being decompiled?JARPackageCompile
- kubernetes實踐之六十:Cabin-Manage Kubernetes
- Node.js NPM Tutorial: Create, Publish, Extend & ManageNode.jsNPM
- MySQL InnoDB Cluster – how to manage a split-brain situationMySqlAI
- ARS Reinforcement Learning using Gymnasium