DBA_TAB_COLUMNS v10

The DBA_TAB_COLUMNS view provides information about all columns in the database.

NameTypeDescription
ownerCHARACTER VARYINGUser name of the owner of the table or view in which the column resides.
schema_nameCHARACTER VARYINGName of the schema in which the table or view resides.
table_nameCHARACTER VARYINGName of the table or view in which the column resides.
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 table or view.
data_defaultCHARACTER VARYINGDefault value assigned to the column.