本文介绍了DBMS_OUTLN和DBMS_OUTLN_EDIT包提供的过程，这些过程用于管理存储的轮廓及其类别。用户需要EXECUTE_CATALOG_ROLE角色来执行DBMS_OUTLN，而公共用户拥有对DBMS_OUTLN_EDIT的执行权限。文章还详细介绍了几种有用的过程，如清除指定轮廓、删除属于特定类别的轮廓等。
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/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-1007355/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
