Oracle 视图 ALL_JSON_DATAGUIDE_FIELDS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_JSON_DATAGUIDE_FIELDS提供了发布和消费JSON数据指南的能力。该视图提供用于访问JSON数据指南特定字段信息的信息，这些信息可帮助应用程序将查询计划优化为高效、容易维护的方式。
其使用方法也很简单，只要使用类似“select * from all_json_dataguide_fields”的查询语句即可。同时，也可以通过使用有助于过滤信息的WHERE子句来启用视图。
另外，开发人员还可以基于ALL_JSON_DATAGUIDE_FIELDS视图编写SQL语句以获取某些字段的具体信息，比如可以使用限定符选择器查询某个特定的字段信息，如“SELECT * FROM ALL_JSON_DATAGUIDE_FIELDS WHERE name=’product_id’”。该视图提供JSON数据指南字段信息，可以帮助让查询更加高效、容易维护，以及更容易解释结果。
官方英文解释
ALL_JSON_DATAGUIDE_FIELDS extracts the path and type information from the data guides accessible to the current user, which are the data guides returned to the user by the ALL_JSON_DATAGUIDE view.
Related Views
-
DBA_JSON_DATAGUIDE_FIELDSextracts the path and type information from all the data guides in the database, which are the data guides returned by theDBA_JSON_DATAGUIDEview. -
USER_JSON_DATAGUIDE_FIELDSextracts the path and type information from all the data guides in the current user’s schema, which are the data guides returned to the user by theUSER_JSON_DATAGUIDEview. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the table containing the JSON column |
|
|
|
|
Name of the table containing the JSON column |
|
|
|
|
Name of the JSON column that has data guide enabled |
|
|
|
|
Path to the JSON field in the data guide |
|
|
|
|
Type of the JSON field in the data guide |
|
|
|
|
Maximum length of the JSON field value, in bytes |
See Also:
-
“DBA_JSON_DATAGUIDE_FIELDS”
-
“USER_JSON_DATAGUIDE_FIELDS”
