ALL_VIEW_COLUMNS v11

The ALL_VIEW_COLUMNS view provides information on all columns in all user-defined views.

NameTypeDescription
ownerCHARACTER VARYINGUser name of the view’s owner.
schema_nameCHARACTER VARYINGName of the schema in which the view belongs.
view_nameCHARACTER VARYINGName of the view.
column_nameCHARACTER VARYINGName of the column.
data_typeCHARACTER VARYINGData type of the column.
data_lengthNUMERICLength of text columns.
data_precisionNUMERICPrecision (number of digits) for NUMBER columns.
data_scaleNUMERICScale of NUMBER columns.
nullableCHARACTER(1)Whether or not the column is nullable – possible values are: Y – column is nullable; N – column does not allow null.
column_idNUMERICRelative position of the column within the view.
data_defaultCHARACTER VARYINGDefault value assigned to the column.