Oracle Database queries the foreign key of the specified table's primary key

Select  B. table_name primary key table name, B. column_name primary key column name, A. table_name foreign key table name, A. column_name foreign key column name  From ( Select  A. constraint_name, B. table_name, B. column_name, A. r_constraint_name  From  User_constraints A, user_cons_columns B  Where A. constraint_type =   '  R  '            And A. constraint_name =  B. constraint_name) ,(  Select   Distinct  A. r_constraint_name, B. table_name, B. column_name  From  User_constraints A, user_cons_columns B  Where A. constraint_type =   '  R  '             And A. r_constraint_name=  B. constraint_name) B  Where A. r_constraint_name = B. r_constraint_name And B. table_name =   '  Hr_duty  '