查表主键列
select cu.*
from dba_cons_columns cu, dba_constraints au
where cu.constraint_name = au.constraint_name
and au.constraint_type = ‘P’
and au.table_name = ‘REQUEST’;
查表约束类型:
select table_name, constraint_name, constraint_type, r_constraint_name
from dba_constraints
where table_name = ‘REQUEST’;
根据键值查表
select cu.*
from dba_cons_columns cu, dba_constraints au
where cu.constraint_name = au.constraint_name
and au.constraint_type = ‘P’
and au.constraint_name = ‘PK_SVIP_BUSINESS_ITEM’;
select cu.*
from dba_cons_columns cu, dba_constraints au
where cu.constraint_name = au.constraint_name
and au.constraint_type = ‘R’
and au.constraint_name = ‘PK_SVIP_BUSINESS_ITEM’;
查找主键被引用的表
select b.table_name, b.column_name
from dba_constraints a
inner join dba_cons_columns b
on a.constraint_name = b.constraint_name
where a.r_constraint_name = ‘PK_SVIP_REQUEST03’;
select b.table_name, b.column_name
from dba_constraints a
inner join dba_cons_columns b
on a.constraint_name = b.constraint_name
where a.r_constraint_name = ‘PK_SVIP_PROCESS_RESULT013’;