Констрейнты: состав и количество

-- Состав отключенных констрейнтов:
--#INTERBASE
ДОПИСАТЬ
--#ORACLE
select ucc.* from all_cons_columns ucc join all_constraints uco on ucc.constraint_name = uco.constraint_name and ucc.owner=uco.owner where uco.status='DISABLED'
and uco.owner='<SCHEME_NAME>'
order by 3;

-- Количество отключенных констрейнтов:
select count(*) from all_constraints where status='DISABLED' and owner='<SCHEME_NAME>';