2.199 ALL_JSON_DATAGUIDE_FIELDS
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_FIELDS
extracts the path and type information from all the data guides in the database, which are the data guides returned by theDBA_JSON_DATAGUIDE
view. -
USER_JSON_DATAGUIDE_FIELDS
extracts 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_DATAGUIDE
view. This view does not display theOWNER
column.
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: