опять я :)
применил
Добавлю что получилось, потом найду если что. Заметил, что в сети хранить гораздо надежнее, чем локально

select * from (
select TC.TABLE_NAME, TC.COLUMN_NAME,
TC.DATA_TYPE||'('||TC.DATA_LENGTH||')'||decode(TC.NULLABLE,'Y','','N', 'NOTNULL', 'ERROR') TYP,
CC.COMMENTS

from ALL_ALL_TABLES T
join all_tab_comments C on C.TABLE_NAME = T.table_name
join all_tab_columns TC on TC.TABLE_NAME = T.table_name
join all_col_comments CC on CC.TABLE_NAME = T.table_name and CC.COLUMN_NAME = TC.COLUMN_NAME
where T.owner = 'MF'
and TC.OWNER = 'MF'
and C.OWNER = 'MF'
and CC.OWNER = 'MF'
and T.table_name = 'EQUIPMENT'
) A
left join (
SELECT
a.table_name CHILD_TAB,
c.column_name CHILD_KEY,
b.table_name PARENT_TAB,
d.column_name PARENT_KEY
FROM
user_constraints a
join user_constraints b on b.CONSTRAINT_NAME = a.R_CONSTRAINT_NAME
join user_cons_columns c on c.CONSTRAINT_NAME = a.CONSTRAINT_NAME
join user_cons_columns d on d.CONSTRAINT_NAME = b.CONSTRAINT_NAME
WHERE
a.table_name = 'EQUIPMENT'
) B
on B.CHILD_TAB = A.TABLE_NAME and B.CHILD_KEY = A.COLUMN_NAME

Спасибо!