ORACLE Êý¾Ý¿â£¨²éѯ Ö÷¼üÍâ¼üÔ¼Êø£©

 --   ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)  
  select   c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name  
  from   user_constraints   c,user_cons_columns   cc,user_cons_columns   rcc  
  where   c.owner='SALIEN_SBGL'  
  and   c.table_name='JH_NDGXLGJH_TB'  
  and   c.constraint_type='R'  
  and   c.owner=cc.owner  
  and   c.constraint_name=cc.constraint_name  
  and   c.r_owner=rcc.owner  
  and   c.r_constraint_name=rcc.constraint_name  
  and   cc.position=rcc.position  
  order   by   c.constraint_name,cc.position;  
   
  --²éѯÁ¬½Óµ½Ä³±íµÄËùÓÐÍâ¼ü(²éij±íµÄËùÓÐ×Ó±í)  
  select   rcc.owner,rcc.table_name,rcc.constraint_name,rcc.column_name,c.table_name,c.constraint_name,cc.column_name      
  from   user_constraints   c,user_cons_columns   cc,user_cons_columns   rcc  
  where   lower(c.owner)='d7i'  
  and   rcc.table_name='R5HOME'  
  and   c.constraint_type='R'  
  and   c.owner=cc.owner  
  and   c.constraint_name=cc.constraint_name  
  and   c.r_owner=rcc.owner  
  and   c.r_constraint_name=rcc.constraint_name  
  and   cc.position=rcc.position  
  order   by   c.constraint_name,cc.position  
   
   
   
  --   ²éѯÖ÷¼üΨһ¼üÔ¼Êø  
  select   c.constraint_name,c.constraint_type,cc.column_name  
  from   user_constraints   c,user_cons_columns   cc  
  where   c.owner='SALIEN_SBGL'  
  and   c.table_name='JH_NDGXLGJH_TB'  
  and   c.owner=cc.own