The USER_VIEW_COLUMNS view provides the information about all columns in views owned by the current user.
Parameter | Type | Description |
---|---|---|
schema_name | CHARACTER VARYING | The name of the schema to which the view belongs. |
view_name | CHARACTER VARYING | The name of the view. |
column_name | CHARACTER VARYING | The name of the column. |
data_type | CHARACTER VARYING | The data type of the column. |
data_length | NUMERIC | The length of the text column. |
data_precision | NUMERIC | The precision of the NUMBER column. The precision is measured with the number of digits. |
data_scale | NUMERIC | The scale of the NUMBER column. |
nullable | CHARACTER(1) |
Specifies whether the column is nullable or not. Valid values:
|
column_id | NUMERIC | The relative position of the column within the view. |
data_default | CHARACTER VARYING | The default value that is assigned to the column. |