Oracle 视图 ALL_INDEXTYPE_OPERATORS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_INDEXTYPE_OPERATORS是一个系统视图，它提供了关于所有可用的操作类型及其定义的信息，其中这些操作类型用于建立和定义索引类型。
使用ALL_INDEXTYPE_OPERATORS查看所有有效的操作符：SELECT * FROM all_indextype_operators;
通常，所有索引类型都要求明确说明操作符，以便对数据库返回结果进行排序。因此，使用ALL_INDEXTYPE_OPERATORS可以帮助您确定想要实现的排序功能
官方英文解释
ALL_INDEXTYPE_OPERATORS lists all operators supported by indextypes accessible to the current user.
Related Views
-
DBA_INDEXTYPE_OPERATORSlists all operators supported by indextypes in the database. -
USER_INDEXTYPE_OPERATORSlists all operators supported by indextypes owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the indextype |
|
|
|
|
Name of the indextype |
|
|
|
|
Name of the operator schema |
|
|
|
|
Name of the operator for which the indextype is defined |
|
|
|
|
Binding number associated with the operator |
See Also:
-
“DBA_INDEXTYPE_OPERATORS”
-
“USER_INDEXTYPE_OPERATORS”
