Fk Referenced Tables

Quote:

---

Originally posted by jmodic
Oracle doesn't have "GRANT REFERENCES ON xy TO wz;" just for looking nicer. Some are actualy using this and having interschema constraints is nothing unusual.

---

Doesn't Oracle really have REFERENCES ON xy TO wz;" just for looking nicer :-)

Now seriously: there are many features in Oracle just for the sake of many features.

Thaks to all of you friends...
But i want the list of foriegn constraint and its referenced table...
something like:

FORIEGN_CONSTRAINT REFERENCED_TABLE REFERENCED_COLUMN
------------------

Code:

---

SELECT uc.constraint_name AS fk_constraint,
      ac.owner AS ref_owner,
      ac.table_name AS ref_table,
      acc.column_name AS ref_column
  FROM ALL_CONSTRAINTS ac,
      ALL_CONS_COLUMNS acc,
      USER_CONSTRAINTS uc
 WHERE ac.constraint_type IN ('P','U')
  AND ac.owner = acc.owner
  AND ac.constraint_name = acc.constraint_name
  AND uc.constraint_type = 'R'
  AND uc.r_owner = ac.owner
  AND uc.r_constraint_name = ac.constraint_name
 ORDER BY uc.constraint_name, acc.position;

---