MY_COLL_TYPES
MY_COLL_TYPES displays information about types of collections created by the current user. By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.
| Name | Type | Description |
|---|---|---|
| owner | character varying(128) | Owner of a cluster. |
| type_name | character varying(128) | Name of a collection. |
| coll_type | character varying(128) | Description of a set. |
| upper_bound | numeric | Not supported. Its value is NULL. |
| elem_type_mod | character varying(7) | Not supported. Its value is NULL. |
| elem_type_name | character varying(128) | Name of the data type or user-defined type on which the collection is based. |
| length | numeric | Not supported. Its value is NULL. |
| precision | numeric | Not supported. Its value is NULL. |
| scale | numeric | Not supported. Its value is NULL. |
| character_set_name | character varying(44) | Not supported. Its value is NULL. |
| elem_storage | character varying(7) | Not supported. Its value is NULL. |
| nulls_stored | character varying(3) | Not supported. Its value is NULL. |
| char_used | character varying(1) | Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
