VIEW: MDSYS.DBA_MD_COLUMNS

Source

View Text - Preformatted

select owner,
       table_name,
       column_name,
       data_type,
       data_length,
       data_precision,
       data_scale,
       0,
       0,
       nullable,
       'N',
       column_id,
       default_length,
       data_default,
       num_distinct,
       low_value,
       high_value
  from all_tab_columns
 where table_name      in ( select mdtname
			      from md$tab )
   and column_name not in ( select cname
			      from md$col )
union all
select a.owner,
       a.table_name,
       a.column_name,
       'HHCODE',
       a.data_length,
       a.data_precision,
       a.data_scale,
       b.ndim,
       b.mxl,
       a.nullable,
       decode(b.pk,0,'N',1,'Y'),
       a.column_id,
       a.default_length,
       a.data_default,
       a.num_distinct,
       a.low_value,
       a.high_value
  from all_tab_columns a, md$col b
 where a.owner = b.owner
   and a.table_name = b.mdtname
   and a.column_name = b.cname

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, COLUMN_NAME
, DATA_TYPE
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, 0
, 0
, NULLABLE
, 'N'
, COLUMN_ID
, DEFAULT_LENGTH
, DATA_DEFAULT
, NUM_DISTINCT
, LOW_VALUE
, HIGH_VALUE
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME IN ( SELECT MDTNAME
FROM MD$TAB )
AND COLUMN_NAME NOT IN ( SELECT CNAME
FROM MD$COL ) UNION ALL SELECT A.OWNER
, A.TABLE_NAME
, A.COLUMN_NAME
, 'HHCODE'
, A.DATA_LENGTH
, A.DATA_PRECISION
, A.DATA_SCALE
, B.NDIM
, B.MXL
, A.NULLABLE
, DECODE(B.PK
, 0
, 'N'
, 1
, 'Y')
, A.COLUMN_ID
, A.DEFAULT_LENGTH
, A.DATA_DEFAULT
, A.NUM_DISTINCT
, A.LOW_VALUE
, A.HIGH_VALUE
FROM ALL_TAB_COLUMNS A
, MD$COL B
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.MDTNAME
AND A.COLUMN_NAME = B.CNAME